Hello all,
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.
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.
Thank you all in advance...
