Nestor,
When I tried this... This is what I got:
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> delete from user where id='root';
ERROR 1054 (42S22): Unknown column 'id' in 'where clause'
mysql> delete from db where id='root';
ERROR 1054 (42S22): Unknown column 'id' in 'where clause'
mysql> flush priveleges;
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 near 'priveleges' at line 1
mysql>
Thanks again....
-Unnsse
On Dec 1, 2005, at 2:45 PM, Nestor wrote:
There is probably a better way but what I do generally is:
1) log in as root
2) use mysql;
3) delete from user where id='root';
4) delete from db where id='root';
5) grant all on *.* to [EMAIL PROTECTED] 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...
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'@'localhost' (using password:
NO)'
dolphin was supposed to be the new password....
If my user name is untz, am I supposed to do this:
untz$ mysqladmin -u untz passwordThatIWantSet
Will this set passwordThatIWantSet to the user untz?
What am I doing wrong?
Any suggestions, tips, and hints will be mostly appreciated.....
Kindest regards,
Unnsse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
