Re: [cobalt-users] MySQL - PHP - PHPMYADMIN - Creating a User

[Jay Summers <jay@xxxxxxxxxxxxxxxxxxxx>]

> I'm sure that one of you experts can help me with this simple problem.
> 
> I have installed MySQL, PHP, and PHPMYADMIN.  All seem to function fine but I
> must be missing something simple.  I am to the point of Dain BRamage.
> 
> Here is what I want to do:  I want to add a USER with a password to fit the
> following scenario.  Let's say that I have a client and he wants to have two
> users with different passwords to be used with his domain name.  Let's say
> that
> the Raq Server IP is 10.0.0.1 and his domain is www.peanuts.com.  His User ID
> is
> 'Charlie' and his password is 'GoodGrief'.  He wants a MySQL Database called
> 'Products' with the USERS to be 'Snoopy' with password of 'WoodStock' and
> 'Linus' with password to be 'Blanket'.  He needs this setup so that his
> software
> package can work.  His software just asks for the MySQL IP Address, Database
> name, DataBase Username, and Database Password.  I got the IP address part
> (grin).
> 
> OK, what are the command lines in MySQL or what are the instructions in
> phpmyadmin?

Well, this is kind of OT, but I'll give you some pointers.

With phpMyAdmin it's easy to create his database. When you get to the
default page, it's got a text box with "Create new Database." Just type
Products into the text box and hit the Create button. That should create his
database and take you to the Products database admin page. Now you need to
setup his username and password.

I'm not really an expert with the MySQL stuff so I'm gonna leave it up to
you to figure out the rest. MySQL has great online documentation. Check out
this URL for the privileges documentation:

http://mysql.com/doc/P/r/Privilege_system.html

You might also want to join the mailing list for MySQL and ask there for
help or search their mailing list archive because I'm sure it's been asked
before.

Good luck ;)

jay