"Ola Ogunneye" <[EMAIL PROTECTED]> wrote:
>
> Let me start out by saying that I am still a newbie. I just freshly
> installed mysql version 4.0.13.
>
> The following are the steps that I took.
>
> Unzipped the binary file in a windows directory.
> Ran setup
>
> Edited my-small.cnf and changed it to my.cnf saved it in the root of my
> C-drive.. (Did not put any password in my.cnf)
>
> Initialized the service startup - Automatic and service was started.
>
> Command Prompt - started the client C:\mysql\bin> mysql -u root mysql
>
> The above gave me the mysql prompt
> Ran the following
>
> mysql>delete from user where Host='%';
> mysql>delete from user where User=' ';
> mysql>delete from db where Host='%';
> mysql>Update user set User='myname', Password=password('mypassword')
> where User='root';
> mysql>flush privileges;
>
> mysql>create database dbasethen
> mysql>create database dbasenow
> mysql>create database dbasewhen
>
> I was able to run all the above without any problem.
>
> My question is concerning security and access for myname. From looking
> at what I have done so far and the sequence, do I need the GRANT command
> to have all privileges on the 3 new databases or did I inherit the
> rights with my Update statement? In other words, do I need to grant
> individual privileges on each database in order to have total control
> over them.
No, you don't need additional privileges for this user, because it has all privileges.
>
> I have seen some statement like the folowing in some of the readings
> that I have come across:
>
> GRANT ALL on dbasethen.* to User "myname"@'localhost';
>
> I am thinking that since myname is now the root user, I have all the
> GRANTS...Please correct me if I am wrong.....And if you could, let me
> know the exact way to grant the privileges.. I am trying touse the
> command line to first set myname up and after I finish that, I will be
> using PHPMYADMIN to do more admin stuff.
The easy way to add new user or to give some premissions to the user is usage of
GRANT statement.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
