Is this a user untz going to do even the create procedure, if yes then
you need to grant super previliege to this user.
grant super on *.* to 'untz'@'localhost' identified by 'password';
regards
anandkl
On 6/11/07, untz [EMAIL PROTECTED] wrote:
Baron Prathima,
Thank for the information!
Hi,
I think you need to log in as root and grant yourself some privileges then. If you
have lost the root password or root doesn't have privileges anymore either, there is a
chapter in the manual on how to do this: http://dev.mysql.com/
Cheers
Baron
untz wrote:
Baron Prathima,
Thank for
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to
untz wrote:
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying to Create Database
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql
Can anyone please help me? I am unable to use MySQL at all, at this
'
identified by 'password';
Not grant super *.* to 'untz'@'localhost' identified by 'password';
Regards,
Mikhail Berman
-Original Message-
From: untz [mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying
untz wrote:
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost' identified by
'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql
Can anyone please help me? I am unable to use MySQL at all,
Gerald,
I tried this and it still didn't work!
Raven:~ untz$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 223 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql grant
Don't you mean this ?
grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog';
- Original Message -
From: untz [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, June 11, 2007 4:36:33 PM (GMT-0500) America/New_York
Subject: Re: Access Denied When Trying to Create
Denied When Trying to Create Database
Gerald,
I tried this and it still didn't work!
Raven:~ untz$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 223 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c
Hello there,
I am using MySQL 5 on OS X Tiger...
After starting the server, I tried to create a sample database and
this is what what happened:
$ mysql -u untz -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version:
Hi untz,
untz wrote:
Hello there,
I am using MySQL 5 on OS X Tiger...
After starting the server, I tried to create a sample database and this
is what what happened:
$ mysql -u untz -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to
Baron Prathima,
Thank for the information!
What happened is that I hadn't used MySQL for a long time and looked
up on the Internet on how to change my root and individual users'
passwords.
The last command the URL had me type was flush privileges; and once
I did that, I think it
14 matches
Mail list logo