469,313 Members | 2,592 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

Another mysql config help...

Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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...

Jul 19 '05 #1
0 1715

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Craig Bailey | last post: by
12 posts views Thread by mistral | last post: by
5 posts views Thread by Jagadish Kumar, Maripi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.