lost root password mysql
after installing ubuntu perfect server 10.04
Code:
http://www.howtoforge.com/perfect-server-ubuntu-10.04-lucid-lynx-ispconfig-3 when trying to log into mysql command line i used this Code:
root@server1:~# mysql -u root -p Code:
root@server1:~# mysql -u root -p Code:
root@server1:~# sudo /etc/init.d/mysql stop Code:
root@server1:~# sudo /etc/init.d/mysql stop kwick |
Maybe in your set-up process MySQL was set-up to listen on a different interface?
Try specifying your actual machine-name on the command-line. |
hhhmmm ok how would i do that? as far as i know nothing has changes all of the data bases are running ok and all of the sites are good. thanks for your reply
kwick |
Did you create another user with a grant privileges ?
If so, try to login as this user. You may check your users with command: mysql> select host, user, password from mysql.user; However, passwords are encrypted and you will not see plain text passwords. If your another user has enough privileges run: mysql> mysqladmin -u root password NEWPASSWORD If you can't do it, try this: http://www.cyberciti.biz/tips/recove...-password.html |
All times are GMT -5. The time now is 05:24 PM. |