New User

Hello, I'm using mysql GUI and I don't know how to create a new user.

Now I'm entering as a root, but I need a different user to connect to,
for my php project.

Another thing is that when I connect to the GUI, it tells me the
forward:
"Either the server service or the configuration file could not be
found. Startup variables and service section are therefore disabled".

What can this mean??
I'm using Xampp.

Thank you a lot!!

kdokdo@gmail.com wrote:
> Hello, I'm using mysql GUI and I don't know how to create a new user.

MySQL "GUI" doesn't really narrow it down. A good tool for this job is
"MySQL Administrator". Log in to your database as root using it, go to
"User administration", and you can add a user. Make sure that you give
your new user some Schema Privileges for the schemas that it needs to
access.

Cheers,
Nicholas Sherlock

--
http://www.sherlocksoftware.org

Thank you very much!

Nicholas Sherlock ha escrito:

> kdokdo@gmail.com wrote:
> > Hello, I'm using mysql GUI and I don't know how to create a new user.
>
> MySQL "GUI" doesn't really narrow it down. A good tool for this job is
> "MySQL Administrator". Log in to your database as root using it, go to
> "User administration", and you can add a user. Make sure that you give
> your new user some Schema Privileges for the schemas that it needs to
> access.
>
> Cheers,
> Nicholas Sherlock
>
> --
> http://www.sherlocksoftware.org

kdokdo@gmail.com wrote:
> Thank you very much!
>
> Nicholas Sherlock ha escrito:
>
>
>>kdokdo@gmail.com wrote:
>>
>>>Hello, I'm using mysql GUI and I don't know how to create a new user.
>>
>>MySQL "GUI" doesn't really narrow it down. A good tool for this job is
>>"MySQL Administrator". Log in to your database as root using it, go to
>>"User administration", and you can add a user. Make sure that you give
>>your new user some Schema Privileges for the schemas that it needs to
>>access.
>>
>>Cheers,
>>Nicholas Sherlock
>>
>>--
>>http://www.sherlocksoftware.org
>
>


Your version will determine the best way to add a new user. If you want to be a
really good DBA-type -learn to do it from SQL - not just the GUI. Any monkey
can be taught to point-click their way through the process...

And most of all - learn to read the documentation. www.mysql.com
--
Michael Austin.
Database Consultant