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
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
Mikhail,
I just tried what you suggested and got this:
mysql grant super privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
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 use
I get this everytime I post to the mysql mailing list?
On Jun 11, 2007, at 1:26 PM, [EMAIL PROTECTED] wrote:
Subject of the message: Re: Access Denied When Trying to Create
Database
Recipient of the message: mysql@lists.mysql.com
mysql@lists.mysql.com
--
MySQL General Mailing List
For
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
, Rolando Edwards wrote:
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
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
]
|
+---
--+
| GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD
'*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C'
| GRANT ALL PRIVILEGES
Brent,
I believe I am experiencing the same problem when trying to run the
CocoaMySQL client...
When I run CocoaMySQL v0.7b2 and try to connect to a database, I get
the following error:
Unable to connect to host localhost.
Be sure that the address is correct and that you have the
Michael,
I would still appreciate it if someone could tell me what the default
port number is because I need that to set up a local JDBC connection.
Kindest regards,
Unnsse
On Dec 2, 2005, at 11:05 PM, Michael Stassen wrote:
untz wrote:
Hello there!
This is a continuation of a previous
Hello again,
I am using OS X Tiger and MySQL 5...
Set a password, yesterday, and wish to change it
How would I go about doing this?
I tried do this:
untz$ mysqladmin -u root password dolphin
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root
] identified by'mypassword';
6) flush privileges;
7) flush privileges;
8) flush privileges;
9) On another shell window I will log in into mysql with the new
password to make
sure that it works.
Nestor :-)
On 12/1/05, untz [EMAIL PROTECTED] wrote:
Hello again,
I am using OS X Tiger and MySQL 5
the original password.
try this:
mysqladmin -u user -p existing password password new_password
That works for me on mysql 4.1.3 on solaris, should be the same for
you.
On Thursday 01 December 2005 16:34, untz wrote:
Hello again,
I am using OS X Tiger and MySQL 5...
Set a password, yesterday
I try to check my installation by
typing mysql, I receive an ERROR message...
Here's the problem at hand:
Raven:~ untz$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Here's my .bash_profile:
Raven:~ untz$ cat .bash_profile
. ~/.profile
Hello there,
I am running MySQL 5 Community Edition on Mac OS X Tiger
Here's what I did:
1. Ran the MySQL server from System Preferences
2. Launched Terminal and typed in the following:
untz$ mysql -u root -p
3. Was prompted for my password, and after entering that in, I
received
15 matches
Mail list logo