root password

[pippin]

where shall i look for the root password?
Can i use /usr/bin/mysqladmin -u root password 123456789 to change the password or is it no need of doing that?

 

[DaDomainMasta]

Originally posted by pippin
where shall i look for the root password?
Can i use /usr/bin/mysqladmin -u root password 123456789 to change the password or is it no need of doing that?

you seems to fall in love with this forum, eh

you mean MySQL root password or system root password?

if first then you are right, except for the following: you can not retrieve the password, just replace with another one.

if second, gotta use some voodoo magic, tell if so, we'll look for a solution

 

[pippin]

Well i have 3 servers that i can use with MySQL and to get a load balance between them i would like to set a root password for MySQL then i can use MySQL Administrator to set permissions on the databases.If i get more domains i must get some balance between them so the sites doesnt get slowed down i guess

 

[DaDomainMasta]

Originally posted by pippin
Well i have 3 servers that i can use with MySQL and to get a load balance between them i would like to set a root password for MySQL then i can use MySQL Administrator to set permissions on the databases.If i get more domains i must get some balance between them so the sites doesnt get slowed down i guess

good idea actually.
check this: http://www.mysql.com/news-and-events/newsletter/2003-04/a0000000157.html

people are worried about load balancing.

actually until you have <10000 hits per day you may not worry about redundancy of mysql servers.

 

[breun]

Under Plesk there is no MySQL account called 'root'. The administrative account is called 'admin' and its password is the same as for the Plesk web interface. You don't want to change the password for the MySQL admin user directly, as you won't be able to login to Plesk anymore (unless you also change the password in /etc/psa/.psa.shadow). The best way to change this is to change the admin password through the Plesk web interface, as this will update both the MySQL account and /etc/psa/.psa.shadow.

You can change your system root password using the 'passwd' command when logged in as root.

 

[pippin]

How do you access the database externally?
I have open port 3306 TCP to the server but i cant access the database with admin and the password and.I want to set up another PLESK or a server with MySQL and mail so i can use this server to only host domains.Is this possible?

And then i maybe can backup mails and the databases and transfer them over to the new server

 

[breun]

Apart from allowing access to port 3306 through the firewall you'll need to allow the MySQL users to connect from remote servers. You can check the output of the following command (% means any IP address):

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e 'SELECT User, Host from mysql.user';

If the Host column has a value that's not localhost, then that user should be able to connect from that host. If it's set to localhost for the users you want to give remote access, you'll need to change that value. (I believe Plesk may have changed the default value for allowing remote access at some point.)