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 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 use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: 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! 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 created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; + --- --+ | Grants for [EMAIL PROTECTED] | + --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' + --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: 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 server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- 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/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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 point... -untz On Jun 11, 2007, at 1:06 PM, Gerald L. Clark wrote: 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 syntax to use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: 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! 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 created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; +-- -- --- --+ | Grants for [EMAIL PROTECTED] | +-- -- --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' +-- -- --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: 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 server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- 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/mysql? [EMAIL PROTECTED] The show grants you ran shows you the proper syntax. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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 near 'privileges on *.* to 'untz'@'localhost' identified by 'maddog'' at line 1 Many, many thanks, untz On Jun 11, 2007, at 1:21 PM, Mikhail Berman wrote: Looks like words privileges on are missing from GRANT statement you used Should be grant super privileges on *.* to 'untz'@'localhost' 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 to Create Database 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 use near '*.* to [EMAIL PROTECTED] identified by password' at line 1 Can anyone please help me? I am not a DBA Kindest regards, untz On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote: 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! 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 created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; +--- - --- --+ | Grants for [EMAIL PROTECTED] | +--- - --- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' +--- - --- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: 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 server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- 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/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Symantec Mail Security detected prohibited content in a message sent from your address (SYM:24166981753914768421)
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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access 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' to clear the buffer. 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 near 'privileges on *.* to 'untz'@'localhost' identified by 'maddog'' at line 1 mysql :( Kindest regards, Unnsse On Jun 11, 2007, at 1:28 PM, Gerald L. Clark wrote: 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, at this point... -untz You have to be logged-in to mysql as a privileged user to grant permissions to others. Logout, and login as root. -- Gerald L. Clark Supplier Systems Corporation -- 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]
Re: Access Denied When Trying to Create Database
Rolando! Yes, that worked! I did have to log into mysql as root, however... BTW, for some odd reason someone's symantec virus checker is sending me denied e-mail responses from Italy, whenever I try to post to the MySQL mailing list. Many, many thanks, Unnsse On Jun 11, 2007, at 1:41 PM, 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 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' to clear the buffer. 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 near 'privileges on *.* to 'untz'@'localhost' identified by 'maddog'' at line 1 mysql :( Kindest regards, Unnsse On Jun 11, 2007, at 1:28 PM, Gerald L. Clark wrote: 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, at this point... -untz You have to be logged-in to mysql as a privileged user to grant permissions to others. Logout, and login as root. -- Gerald L. Clark Supplier Systems Corporation -- 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/mysql? [EMAIL PROTECTED] -- 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]
Access Denied When Trying to Create Database
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: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql What could I be possibly be doing wrong? Many, many thanks, untz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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 created a problem for everything else. Here's what I got when I ran SHOW GRANTS: mysql show GRANTS; +--- --+ | Grants for [EMAIL PROTECTED] | +--- --+ | GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD '*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C' | GRANT ALL PRIVILEGES ON `depot_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `depot_production`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_development`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost' | GRANT ALL PRIVILEGES ON `music_production`.* TO 'untz'@'localhost' +--- --+ 7 rows in set (0.00 sec) What am I supposed to do? I can not run queries or even create tables... I also tried using a MySQL client (CocoaMySQL) and it displayed the same error as in the previous e-mail (see below). Am really stuck on this so any help, suggestions, etc. would be greatly appreciated! Sincerely yours, untz On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote: 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 server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database people_development; ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to database 'people_development' mysql Try running SHOW GRANTS while logged in, and see what privileges you have. You probably need to grant your user some additional privileges. Cheers Baron -- 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]
Re: mysql on OS X tiger
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 necessary privileges. MySQL said: Client does not support authentication protocol requested by server; consider upgrading MySQL client Am using MySQL 5 on OS X Tiger... However, I can't seem to find the my.cnf file under /etc - it doesn't exist! Kindest regards, Unnsse On Dec 2, 2005, at 1:29 PM, Brent Baisley wrote: I'm guessing that you are running 10.4.3 on your Powerbook. In this latest update, Apple took extra security measures and starts MySQL with the --skip-networking option. This means only processes running on the local machine can connect to it (through a Unix socket file), like PHP running under Apache or the mysql client. This is a good security measure. You can change this by editing the /etc/my.cnf file, comment out the skip-networking line and restart mysql. On Dec 2, 2005, at 3:54 PM, YL wrote: I'm setting up a mysql server on OS X Tiger powerbook for development. I've also a mysql server on my win2k pro machine. Tiger has ip 192.168.0.100 and win2k has ip 192.168.0.101 Both db servers work fine locally but I can connect from Tiger to Win2k while not from win2k to Tiger. The version of mysql on Tiger is 5.0.16, the version of mysql on win2k is 5.0.15. Other than that, I did almost nothing in configuring mysql on Tiger and win2k. Can anyone tall me what to do in order to make mysql connection from win2k to tiger? Thanks -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- 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]
Re: CocoaMySQL v0.7b2 Connection Help, Part II
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 posting of mine... I noticed that that the CocoaMySQL v0.7b2 client lists the Database, Socket, and Port fields as optional, so I filled the other fields and when I clicked on Connect, I received this error message: Unable to connect to host localhost. Be sure that the address is correct and that you have the necessary privileges. MySQL said: Client does not support authentication protocol requested by server; consider upgrading MySQL client Has anyone used CocoaMySQL v0.7b2 with MySQL 5 on OS X Tiger? What is the default port number? Kindest regards, Unnsse If you are connecting to the mysql server on localhost, the port is irrelevant as you are connecting via unix socket. The error message indicates that your client (CocoaMySQL v0.7b2) was compiled against the mysql 4.0 library. Authentication was changed to make it more secure in 4.1. See the manual for details and workarounds http://dev.mysql.com/doc/refman/5.0/en/old- client.html. Michael -- 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]
Help resetting password on MySQL 5
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/[EMAIL PROTECTED]
Re: Help resetting password on MySQL 5
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]
Re: Help resetting password on MySQL 5
Ok, this worked... My question is that is the password for 'root' supposed to match the sudo password used to grant super priveleges to the bash user? I purposely wanted this different and changed my root password on mysqladmin to something else... Is it supposed to be the same as the root's system password? Kindest regards, Unnsse On Dec 1, 2005, at 2:52 PM, sean c peters wrote: First, you need to supply your existing password to mysqladmin so that it knows that you areauthorized to perform the admin action. Otherwise, anyone could change passwords, without knowing 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, 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 -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] The software required Windows 2000 or better, so i Downloaded Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with MySQL 5 on OS X Tiger
Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger... Ran the installer and it installed everything to /usr/local/ ... Updated my .bash_profile by creating a MYSQL_HOME variable and appending that MYSQL_HOME/bin to the PATH variable... Now, the problem is that when 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 AXIS_HOME=/Developer/axis-1_3; AXIS_LIB=$AXIS_HOME/lib; AXISCLASSPATH=$AXIS_LIB/axis.jar:$AXIS_LIB/commons-discovery.jar: $AXIS_LIB/commons-logging.jar:$AXIS_LIB/jaxrpc.jar:$AXIS_LIB/saaj.jar: $AXIS_LIB/log4j-1.2.8.jar:$AXIS_LIB/xml-apis.jar:$AXIS_LIB/ xercesImpl.jar; JAVA_HOME=/System/Library/frameworks/JavaVM.framework/Versions/1.5.0/ Home; J2EE_HOME=/Developer/JavaTools/j2sdkee1.3.1; J2ME_HOME=/Developer/JavaTools/j2me_wireless_toolkit2.2; CATALINA_HOME=/Developer/JavaTools/tomcat/jakarta-tomcat-5.5.9; MYSQL_HOME=/usr/local/mysql CLASSPATH=.:$J2EE_HOME/lib/j2ee.jar:$CATALINA_HOME/common/lib/ servlet-api.jar:$CATALINA_HOME/common/lib/jsp-api.jar:/Developer/ Database/hsqldb/lib/hsqldb.jar; PATH=$PATH:$JAVA_HOME/bin:$J2EE_HOME/bin:$J2ME_HOME/bin:/usr/local/ bin:/opt/local/bin:$MYSQL_HOME/bin; VIMRUNTIME=/Applications/Vim.app/runtime; export AXIS_HOME AXIS_LIB AXISCLASSPATH JAVA_HOME J2ME_HOME J2EE_HOME CATALINA_HOME MYSQL_HOME PATH VIMRUNTIME bash Can anyone tell me what possibly I am doing wrong? Many, many thanks! -Unnsse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie help with MySQL
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 this message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I just installed MySQL 5 on my PowerBook, and haven't touched any of the configuration files Am I following the right steps? I am trying to get the command line to welcome me with: Welcome to MySQL monitor. Comands end with ; or \g. After this, I would like to create some tables. Does anyone know what I am doing wrong? Many, many thanks! -Unnsse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
