Topic: MySQL login questions

[Thomas]

I am assumimg that SME server 6.0.1 has MySQL installed. I would like to connect the MySQL database on my SME server from a client on the same LAN network as the server using MySQL Administrator.  What is the username and password? Also, what port is it listening on?

Thanks,
Thomas

[mrjhb3]

Port is 3306.  As far as connecting to it, if you search the forums for phpmyadmin, you will see someone has already created an rpm for that.  It is accessible from server-manager.  If that is not what you want, then you should create a user and give it the appropriate rights.

i.e.
grant all privileges on *.* to user@localhost identified by 'password' with grant option;
flush privileges;

This should create a user that has all rights to all databased.

HTH,

JB

[Thomas]

Thanks!