# mysql -u root mysqlmysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';mysql> FLUSH PRIVILEGES;mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -pEnter password:
Thursday, March 26, 2009
Solve Access denied for user 'root'@'localhost' (using password: NO) in MySQL
# /etc/init.d/mysql stop# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysqlmysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';mysql> FLUSH PRIVILEGES;mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -pEnter password:mysql>
# mysql -u root mysqlmysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';mysql> FLUSH PRIVILEGES;mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -pEnter password:
Subscribe to:
Post Comments (Atom)
-
Connect to the ESXi host with SSH Stop the USB arbitrator service. This service is used to passthrough USB device from an ESX/ESXi host to...
-
If you see an error like SMTP -> ERROR: Failed to connect to server: Permission denied (13) , you may be running into SELinux preventing...
-
Exchange Server 2013 Unable to access OWA or ECP. - "Something went wrong" or "500 unexpected error"Open the ADSI editor on the primary domain controller Go to CN=Configuration --> CN=Services --> CN=Microsoft Exchange --> CN=...
No comments:
Post a Comment