Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Thomas on April 19, 2005, 02:31:45 AM

Title: MySQL login questions
Post by: Thomas on April 19, 2005, 02:31:45 AM

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

Title: MySQL login questions
Post by: mrjhb3 on April 19, 2005, 03:56:14 AM

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

Title: MySQL login questions
Post by: Thomas on April 19, 2005, 05:41:59 AM

Thanks!