: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2007 7:09 AM
To: Lopez, Denise; mysql@lists.mysql.com
Subject: Re: Database creation question
You might try issueing a FLUSH PRIVILEGES command instead of restarting.
This is supposed to be implicit when you use the GRANT
statement
: Database creation question
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use :
mysql GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@%
IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
Regards,
Juan
]
To: mysql@lists.mysql.com
Sent: Tuesday, March 20, 2007 7:55 PM
Subject: RE: Database creation question
That still didn't work. I think I just need to restart the mysql
service.
Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB 1020
Los
Hello everyone,
I had a really weird thing happen and I was wondering if anyone has seen
anything like this. From a shell command line I connected to a running
instance of mysql with the mysql -u root -p command. I successfully get
to a mysql prompt. I needed to create a new database and user for
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use :
mysql GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@%
IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
Regards,
Juan Eduardo
On 3/20/07, Lopez,
Moreno [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 4:03 PM
To: Lopez, Denise
Cc: mysql@lists.mysql.com
Subject: Re: Database creation question
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use