Installing mysql server on Debian Etch

brgsousa · 08-07-2008, 01:33 PM

I am using debian etch and need to install mysql server this way:

Code:

# aptitude install mysql-server

# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I entered none when asked for password.

Why is that happening?

Thanks

farslayer · 08-07-2008, 03:38 PM

Did you actually type none or did you simply hit ENTER as directed ? Pressing ENTER without typing anything should have worked, if not there is another possibility

Did you have mysql-server installed previously ? if so it could be looking at the old password. you could try purging mysql-server and then re-installing it.

aptitude purge mysql-server
aptitude install mysql-server-5.0

brgsousa · 08-08-2008, 05:16 AM

Lol, I simply hit ENTER as directed. My english is not that good, that's why you misunderstood me. I had mysql server previously installed, and I did purge it as you said. It didn't work.

In order to make it work I did this (But i don't it is the best way coz once I installed it with mysql_secure_installation):

apt-get install mysql mysql-server

There is often a problem with mysql to setup the root password. So the best thing to do is first stopping mysql:

/etc/init.d/mysql stop

Then update the user table

mysqld --skip-grant-tables --skip-networking &

mysql mysql

UPDATE user SET password=PASSWORD('yourrootpassword') WHERE User="root" AND Host="localhost";

quit

/etc/init.d/mysql restart