I've been using MySQL on a local Windows host and connecting using the Root user. Now
I want to create a user that can only access the database used by an application. I've
created the user with no Global privileges and granted Database privileges for that
database. However, when I try to connec
On Mon, 11 Jun 2001, h3rb wrote:
> Ok. I have read the manual =) But one thing I am not clear on. Is if I can
> create a user who can create their own database's..modify them..and drop them
> if need be. But they wouldn't have access to any database on the server. I
> am asking because I hos
Ok. I have read the manual =) But one thing I am not clear on. Is if I can
create a user who can create their own database's..modify them..and drop them
if need be. But they wouldn't have access to any database on the server. I
am asking because I host 4 different sites and 3 of them want
Muhanad Mustafa wrote:
>
> Ok, i'm very new to Mysql. . The documentation is a little confusing for me to
>figure out so I thought this might help. I had created a database on my system
>called "customer15"
>
> I did this
>
> mysql>create database customer15
>
> Now I want to setup a mysql
MySQL has nothing to do with /etc/passwd
You need to look at the mysql by typing in
mysql -u root -p mysql
Then you type in
DESCRIBE mysql
You should see somehting like the user table.
All you have to do is use INSERT INTO sql statements or even look up the mysql
manual for the usage of GR
Ok, i'm very new to Mysql. . The documentation is a little confusing for me to figure
out so I thought this might help. I had created a database on my system called
"customer15"
I did this
mysql>create database customer15
Now I want to setup a mysql username and password so this customer has
