Carlos Corzo writes:
> Hello,
>
> Other than installing the .pkg file into the server and running it
> through his interface, do I need to get the server admin to do anything
> else? I am afraid that I am running out of time with him, meaning, I am
> running out of time with root priviledges. I am trying here. We have
> tried all sorts of crap but nothing. What would be beautiful is just a
> small sample creation of a database. I have tried the sample I have but
> did not work very well!
Hi!
Alright, there are only a few steps where you need your admin
guy. Here's what you need to do:
shell> mysqladmin -u root --password=? create carlos_database
shell> mysql -u root --password=? mysql
-> GRANT ALL ON carlos_database.* TO carlos@"%_" IDENTIFIED BY
-> 'carlos_password';
-> FLUSH PRIVILEGES;
-> exit;
After this is done, you (Carlos) will be able to connect to your
database 'carlos_database' (or whatever you want to call it) as user
'carlos' (again, or whatever you chose for a username) with password
'your_password' (again, you can guess what I'm about to say :).
Once connected you can create all tables and whatnot yourself.
Note that the SQL Grant statement above will allow the user 'carlos'
to connect from _any_ machine. This *may* be a security issue...? But
without knowing more about your exact needs, this should work.
For more info about GRANT look at:
http://www.mysql.com/manual.php?section=GRANT
For clarity, note that 'shell>' indicates the UNIX Shell -- and '->'
indicates the MySQL Shell.
Hope everything works for you!
Matt
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a message to:
<[EMAIL PROTECTED]>
If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
http://lists.mysql.com/php/unsubscribe.php
