Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: Sergiomadeira on December 16, 2009, 05:57:08 PM

Title: New user (create Database and user for PHP list
Post by: Sergiomadeira on December 16, 2009, 05:57:08 PM

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

Title: Re: New user (create Database and user for PHP list
Post by: cactus on December 16, 2009, 07:03:57 PM

Quote from: Sergiomadeira on December 16, 2009, 05:57:08 PM

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

Title: Re: New user (create Database and user for PHP list
Post by: Sergiomadeira on December 16, 2009, 09:29:03 PM

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

Title: Re: New user (create Database and user for PHP list
Post by: Stefano on December 16, 2009, 09:35:25 PM

Sergio, you shoul read again that page, starting from here (http://wiki.contribs.org/MySQL#Allow_mysql_login_from_any_LAN_workstation)

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

Title: Re: New user (create Database and user for PHP list
Post by: cactus on December 16, 2009, 10:13:00 PM

Quote from: Sergiomadeira on December 16, 2009, 09:29:03 PM

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/

Title: Re: New user (create Database and user for PHP list
Post by: Sergiomadeira on December 16, 2009, 11:23:51 PM

Thank you to both of you.

Regards
Sergio