Topic: MySql user/password

[slacker]

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

[judgej]

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