[SOLVED] Can't set up mysql, get error: 'Access denied for user 'root'@'localhost'

jddancks · 01-16-2013, 11:24 PM

After installing mysql-client and mysql-server I run

Code:

/usr/bin/mysql_install_db

I try to create the root against:

Code:

root@jdd:~# /usr/bin/mysqladmin -u root password '*******'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

So what did I forget to do?

system is debian on old powerpc emac

bijo505 · 01-17-2013, 02:26 AM

Quote:

Originally Posted by jddancks

After installing mysql-client and mysql-server I run

Code:

/usr/bin/mysql_install_db

I try to create the root against:

Code:

root@jdd:~# /usr/bin/mysqladmin -u root password '*******'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

So what did I forget to do?

system is debian on old powerpc emac

Hi Jddancks,

Are you trying to reset the password using mysqladmin? If yes the syntax would be

Code:

root@yetwait:~# mysqladmin -uroot -p password 'Newpasswd'
Enter password: #Here you need to give the old password.
root@yetwait:~#

So after that you can login to the mysql using your new password

Code:

$mysql -u root -p

Or if you forgot the old password, you can reset with the help of below.

Code:

# /etc/init.d/mysql stop
# mysqld --skip-grant-tables --user=root&
# mysql
mysql> use mysql
mysql> update user set Password='' where User='root';
mysql> exit
# killall -9 mysqld
# /etc/init.d/mysql start
# mysql -p
Enter password:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');
mysql> FLUSH PRIVILEGES;
mysql> exit

Also please have a look at the following URL, that will help you to reset password

http://dev.mysql.com/doc/refman/5.1/...ss-denied.html
http://dev.mysql.com/doc/refman/5.1/...passwords.html

jddancks · 01-17-2013, 11:02 AM

Quote:

Originally Posted by bijo505

Hi Jddancks,

Are you trying to reset the password using mysqladmin? If yes the syntax would be

Code:

root@yetwait:~# mysqladmin -uroot -p password 'Newpasswd'
Enter password: #Here you need to give the old password.
root@yetwait:~#

So after that you can login to the mysql using your new password

Code:

$mysql -u root -p

Or if you forgot the old password, you can reset with the help of below.

Code:

# /etc/init.d/mysql stop
# mysqld --skip-grant-tables --user=root&
# mysql
mysql> use mysql
mysql> update user set Password='' where User='root';
mysql> exit
# killall -9 mysqld
# /etc/init.d/mysql start
# mysql -p
Enter password:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');
mysql> FLUSH PRIVILEGES;
mysql> exit

Also please have a look at the following URL, that will help you to reset password

http://dev.mysql.com/doc/refman/5.1/...ss-denied.html
http://dev.mysql.com/doc/refman/5.1/...passwords.html

Thanks bijo505. I did the procedure for resetting the password. I messed with my server awhile back, I think it made me create the root account for mysql during the installation process. I thought I would've set it the same as the regular password for root (don't worry I don't plan on launching a website or anything, this is just for fun). I thought I could simply re-install mysql and set it back up after I realized I didn't write it down D:.

also Dijo505, or any mod, if you see this can you please censor the password, I posted this late at night I wasn't thinking.