Repute:
> ...i cant manage it to do this with putty via root
> login would you please make a description of
> how to manage changing this.
Hi. Is that server your own server (under your full control) or it is from a hosting service?
If it is your own server, you can login and then invoke the mysql client by typing:
Code:
mysql --user root --password
Then you will be asked to enter the root password (of the MySQL root user, not the system root user).
To check what are the accounts for MySQL you can type this:
Code:
use mysql;
That will select the "mysql" database. Then you enter the following SQL query.
Code:
select host,user,password from user;
There you can see the passwords as hashes and the hosts allowed for each user. For example, I get an output like this:
Code:
+------+------------------------+------------------+
| user | host | password |
+------+------------------------+------------------+
| root | localhost | a174b1193efdd17c |
| root | 192.168.0.% | a174b1193efdd17c |
| root | wintermute | a174b1193efdd17c |
+------+------------------------+------------------+
| user | host | password |
+------+------------------------+------------------+
| root | localhost | a174b1193efdd17c |
| root | 192.168.0.% | a174b1193efdd17c |
| root | wintermute | a174b1193efdd17c |
+------+------------------------+------------------+
That result shows that my "root" account has three allowed hosts to connect from: localhost, wintermute (the proper hostname) and from any computer in my LAN (the 192.168.0 network).
Then you can change the user password type by typing:
Code:
set password for 'root'@'localhost'=old_password('mynewpass');
You will need to do that for every host.
Of course this would be more simple if you already have a web interface like phpmyadmin, where you can simply use your web browser with a graphical interface to execute the SQL instructions.
If you have more questions, comments or suggestions, please post to this forum.
Regards,
Mario A. Valdez-Ramirez.