mysqladmin -u root password 'pickapassword'
or better, run mysql_secure_installation
Code:# mysqladmin -u root password PASSWORD mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
# mysqld_safe --skip-grant-tables &
. Login to mysql as root: mysql -u root
, set the new password with the following:mysql> use mysql;
mysql> update user set password=PASSWORD("PASSWORD") where user='root';
mysql> flush privileges;
mysql> quit
service mysql-server restart
That should fix it.Looks like the password is already set to something. You can reset it by stopping the mysql server and starting it back up with# mysqld_safe --skip-grant-tables &
. Login to mysql as root:mysql -u root
, set the new password with the following:
Code:mysql> use mysql; mysql> update user set password=PASSWORD("PASSWORD") where user='root'; mysql> flush privileges; mysql> quit
restart mysqld withservice mysql-server restart
That should fix it.
Looks like the password is already set to something. You can reset it by stopping the mysql server and starting it back up with# mysqld_safe --skip-grant-tables &
. Login to mysql as root:mysql -u root
, set the new password with the following:
Code:mysql> use mysql; mysql> update user set password=PASSWORD("PASSWORD") where user='root'; mysql> flush privileges; mysql> quit
restart mysqld withservice mysql-server restart
That should fix it.