Topic: New user (create Database and user for PHP list

[Sergiomadeira]

Hi all

I'm a newby and I just setup my machine running SME Server.

I wan't to use this to install php list and send out my personal newsletters but before i install php list I need some help to create a database and a user with the right permissions.

I think the code to create the database is:
mysqladmin create 'dbname' --default-character-set=utf8

But what is the sintaxe to create a user with the right permissions for this database?


thanks
Sergio

[cactus]

Hi all

I'm a newby and I just setup my machine running SME Server.

I wan't to use this to install php list and send out my personal newsletters but before i install php list I need some help to create a database and a user with the right permissions.

I think the code to create the database is:
mysqladmin create 'dbname' --default-character-set=utf8

But what is the sintaxe to create a user with the right permissions for this database?

Next time please try and search. I am sure you would have found this: http://wiki.contribs.org/MySQL

[Sergiomadeira]

Hello

Thank you for your reply, but if you have looked at my:
"I think the code to create the database is:
mysqladmin create 'dbname' --default-character-set=utf8"

Can you see that this code was inside that documentation you just send me, I allredy looked at it but in there the exaple when creating a user for the database is a user with read only rights and this is my question:

How to create a user with all the necessary rights.

Thanks in advance
sergio

[Stefano]

Sergio, you shoul read again that page, starting from here

starting from "You probably want to change: " you'll find exactly what you are asking for

please, take some time to read all the documentation, thank you

[cactus]

Can you see that this code was inside that documentation you just send me, I allredy looked at it but in there the exaple when creating a user for the database is a user with read only rights and this is my question:

How to create a user with all the necessary rights.

I wrote large parts of it, so yes I know what is in there.

For specific MySQL commands you should read the MySQL manual, although the configuration file and login in to MySQL might be a little different on SME Server inside the MySQL engine nothing is different to normal as described in the manual: http://dev.mysql.com/doc/refman/4.1/en/

[Sergiomadeira]

Thank you to both of you.

Regards
Sergio