Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: slacker on August 19, 2006, 05:49:50 AM

Title: MySql user/password
Post by: slacker on August 19, 2006, 05:49:50 AM

I am a fairly new to SME, so be kind

I have been able to configure and run the mail/web/webmail servers w/o problem.  (very nice).

My question is, I am trying to install a program that needs access to mysql:
-User: A user with accces to that database(must have rights to create and modify tables)
-Password: The password for that user

I've done a search ( tried using root with no password and 'passw0rd' ), but have been unsuccessful and geting a user and password combo to work.

Can someone point me in the right direction.

TIA

Title: Re: MySql user/password
Post by: judgej on August 19, 2006, 10:01:36 PM

Log into the server command line as root, using a putty or a similar terminal, or direct into the console. Then use the 'mysql' command to create a new user with as many rights as you need. The 'root' user will be able to connect direct to the database without having to enter the password.

-- JJ