Thursday, May 10, 2012

Mysql : ERROR 1045 (28000) | Solution

root@lucid32:/home/vagrant# mysql -u root -w 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

root@lucid32:/home/vagrant# /etc/init.d/mysql stop

root@lucid32:/home/vagrant# mysqld_safe --skip-grant-tables &
[1] 1152
root@lucid32:/home/vagrant# 120509 19:36:25 mysqld_safe Logging to syslog.
120509 19:36:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

root@lucid32:/home/vagrant# ^C
root@lucid32:/home/vagrant# /etc/init.d/mysql start 
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
mysql start/running, process 1297

root@lucid32:/home/vagrant# mysql --user root -w 

root@lucid32:/home/vagrant# sudo mysqladmin -u roor password 12345

0 comentários:

Post a Comment