Re: password problem
Data directory path mention in cnf is of old mysql. Make a fresh data directory, configure it in configuration file and execute mysqlinstall_db, I don't understand the sentence about the data directory path mention. The my.cnf file is at /etc/my.cnf . It doesn't have any data directory path mention, but neither does the my.cnf file on a laptop, which works. So there seems to be nothing wrong with the location or content of the my.cnf file. On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller martinmuel...@northwestern.edumailto:martinmuel...@northwestern.edu wrote: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same. Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks and Regards: Nikhil Anand +91 9650024197
Re: password problem
Am 31.07.2015 um 14:40 schrieb Martin Mueller: Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). But if I do this with the command 'mysql -u mysql I get the answer Access denied for user 'mysql'@'localhost' (using password: NO) I can do this as super user or normal, and I can try passwords from earlier installations, but none of them work. So I am stopped dead in my tracks, am I not? what do you not understand in: Resetting the Root Password: Generic Instructions Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option jesus christ, put skip-grant-tables in your my.cnf, make sure the server is not reachable from outside and just type myysql -u root and don't forget remove skip-grant-tables after you defined a password you are knowing and restarting the server again As for the datadir, the command update db locate mysql works on the Mac and gives me info about a whole set of files in /usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and I deleted a previous installation because I had moved the data I needed to another machine. I'm not a very experienced programmer and have trouble wrestling with the command line. But I think I did my due diligence and didn't find any open doors. well, you have a bad mix * missing knowledge * a blackbox with a installer * refusing to read more than the begin of docs On 7/31/15 3:36 AM, Reindl Harald h.rei...@thelounge.net wrote: first: don't reply off-list, a answer on a mailing-list is no invitation for private support! Am 31.07.2015 um 02:34 schrieb Martin Mueller: I read that section but was stopped in my tracks by Log on to your system as the Unix user that the MySQL server runs as (for example, mysql) Because I have no password for ANY thing. read the f**ng https://dev.mysql.com/doc/refman5.0/en/resetting-permissions.html https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html - unbelievebale that users these days need anything ready chewed and are too lazy to click on a link and read more than 5 lines Resetting the Root Password: Generic Instructions Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option I used the uninstall routine recommended by Rob Allen, in which you remove the directories /usr/local/mysql as well as /usr/local/mysql* and a lot of other library and etc files. So there is no trace of the old system on my machine. How come a routine installation of mysql then locks up the application. the datadir is *not* removed by any sane installer, dunno where it lives on Apple machines since i banned them 5 years ago for good reasons on a non-OSX i would just type updatedb; locate mysql als root On 7/30/15, 19:22, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same * install and uninstall *never* removes the datadir * users and permissions are in the DB mysql * https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html signature.asc Description: OpenPGP digital signature
Re: password problem
Am 31.07.2015 um 16:23 schrieb Martin Mueller: Dear Mr Harald, I've learned some things from your responses and even more from shawn green's. You might learn a lot from him about patience and courtesy, which make life on a technical forum a lot easier. You clearly know a lot about technical stuff, but you're short on patience, and it would help you a lot to practice a little courtesy and refrain from vulgar language. well, i am developer and sysadmin, not a politican my first response pointed again to the docs and quotet that: Resetting the Root Password: Generic Instructions Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option https://www.google.at/search?q=skip-grant-tables would have flooded you with informations P.S.: on the right side of the docs page is a Section Navigation with a link https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-generic On 7/31/15 9:12 AM, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 15:40 schrieb shawn l.green: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes on a Linux/Unix/Mac machine executes in the context of some kind of user account (the system login). By default, mysqld (the database server daemon) is installed to run under the host machine user account 'mysql'. It can be changed if you want to change it but that is the default. That is why 'mysql' was listed in the for example section of that instruction but this part of the docs is completly bullshit a) on no sane system the user mysql has a password, hence no login possible and typically it has also no shell configured b) for what reason mysql -u root and you are done with skip-grant-tables (and skip-grant-tables is the only relevant point) why in the world should i need to logon as the user mysqld runs for connect to mysqld? but anyways, mysql -u mysql would have worked also as well as mysql -u bullshit because skip-grant-tables does what it says, you can do anything you like to do signature.asc Description: OpenPGP digital signature
Re: password problem
Am 31.07.2015 um 14:45 schrieb Martin Mueller: Data directory path mention in cnf is of old mysql. Make a fresh data directory, configure it in configuration file and execute mysqlinstall_db, I don't understand the sentence about the data directory path mention. The my.cnf file is at /etc/my.cnf . It doesn't have any data directory path mention, but neither does the my.cnf file on a laptop, which works. So there seems to be nothing wrong with the location or content of the my.cnf file. your current problem is that you have no clue where your mysql-datadir is *because* it's some random default, from the moment on you specify it a) you know it - good for a million reasons b) it is empty and you can start from scratch or you seek the current one and make the folder empty and start with mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist. On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller martinmuel...@northwestern.edumailto:martinmuel...@northwestern.edu wrote: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same. Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks and Regards: Nikhil Anand +91 9650024197 -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development m: +43 (676) 40 221 40, p: +43 (1) 595 3999 33 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: password problem
Am 31.07.2015 um 15:40 schrieb shawn l.green: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes on a Linux/Unix/Mac machine executes in the context of some kind of user account (the system login). By default, mysqld (the database server daemon) is installed to run under the host machine user account 'mysql'. It can be changed if you want to change it but that is the default. That is why 'mysql' was listed in the for example section of that instruction but this part of the docs is completly bullshit a) on no sane system the user mysql has a password, hence no login possible and typically it has also no shell configured b) for what reason mysql -u root and you are done with skip-grant-tables (and skip-grant-tables is the only relevant point) why in the world should i need to logon as the user mysqld runs for connect to mysqld? but anyways, mysql -u mysql would have worked also as well as mysql -u bullshit because skip-grant-tables does what it says, you can do anything you like to do signature.asc Description: OpenPGP digital signature
Re: password problem
Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). But if I do this with the command 'mysql -u mysql I get the answer Access denied for user 'mysql'@'localhost' (using password: NO) I can do this as super user or normal, and I can try passwords from earlier installations, but none of them work. So I am stopped dead in my tracks, am I not? As for the datadir, the command update db locate mysql works on the Mac and gives me info about a whole set of files in /usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and I deleted a previous installation because I had moved the data I needed to another machine. I'm not a very experienced programmer and have trouble wrestling with the command line. But I think I did my due diligence and didn't find any open doors. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 3:36 AM, Reindl Harald h.rei...@thelounge.net wrote: first: don't reply off-list, a answer on a mailing-list is no invitation for private support! Am 31.07.2015 um 02:34 schrieb Martin Mueller: I read that section but was stopped in my tracks by Log on to your system as the Unix user that the MySQL server runs as (for example, mysql) Because I have no password for ANY thing. read the f**ng https://dev.mysql.com/doc/refman5.0/en/resetting-permissions.html https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html - unbelievebale that users these days need anything ready chewed and are too lazy to click on a link and read more than 5 lines Resetting the Root Password: Generic Instructions Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option I used the uninstall routine recommended by Rob Allen, in which you remove the directories /usr/local/mysql as well as /usr/local/mysql* and a lot of other library and etc files. So there is no trace of the old system on my machine. How come a routine installation of mysql then locks up the application. the datadir is *not* removed by any sane installer, dunno where it lives on Apple machines since i banned them 5 years ago for good reasons on a non-OSX i would just type updatedb; locate mysql als root On 7/30/15, 19:22, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same * install and uninstall *never* removes the datadir * users and permissions are in the DB mysql * https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: password problem
Dear Mr Harald, I've learned some things from your responses and even more from shawn green's. You might learn a lot from him about patience and courtesy, which make life on a technical forum a lot easier. You clearly know a lot about technical stuff, but you're short on patience, and it would help you a lot to practice a little courtesy and refrain from vulgar language. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 9:12 AM, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 15:40 schrieb shawn l.green: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes on a Linux/Unix/Mac machine executes in the context of some kind of user account (the system login). By default, mysqld (the database server daemon) is installed to run under the host machine user account 'mysql'. It can be changed if you want to change it but that is the default. That is why 'mysql' was listed in the for example section of that instruction but this part of the docs is completly bullshit a) on no sane system the user mysql has a password, hence no login possible and typically it has also no shell configured b) for what reason mysql -u root and you are done with skip-grant-tables (and skip-grant-tables is the only relevant point) why in the world should i need to logon as the user mysqld runs for connect to mysqld? but anyways, mysql -u mysql would have worked also as well as mysql -u bullshit because skip-grant-tables does what it says, you can do anything you like to do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: password problem
On 7/31/2015 8:40 AM, Martin Mueller wrote: Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes on a Linux/Unix/Mac machine executes in the context of some kind of user account (the system login). By default, mysqld (the database server daemon) is installed to run under the host machine user account 'mysql'. It can be changed if you want to change it but that is the default. That is why 'mysql' was listed in the for example section of that instruction. But if I do this with the command 'mysql -u mysql I get the answer No. That is how you log into mysqld to open a MySQL client session. The instruction was to login to your operating system as the user that mysqld operates as. These are fundamentally different accounts at two very different levels. Access denied for user 'mysql'@'localhost' (using password: NO) I can do this as super user or normal, and I can try passwords from earlier installations, but none of them work. So I am stopped dead in my tracks, am I not? That is because you didn't add this line to the [mysqld] section of your configuration file before you started mysqld. skip-grant-tables If you had, you would not have needed to use any passwords at all. This command (on the system prompt) would be all you need to connect to your now completely-unlocked database server (see the third section of generic instructions that work on any platform). mysql As for the datadir, the command update db locate mysql works on the Mac and gives me info about a whole set of files in /usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and I deleted a previous installation because I had moved the data I needed to another machine. I'm not a very experienced programmer and have trouble wrestling with the command line. But I think I did my due diligence and didn't find any open doors. The door is there, you just just need to be able to see it as a door. Just a little more experience working on the command line will help. ... remainder snipped ... -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Integrated Cloud Applications Platform Services Office: Blountville, TN Become certified in MySQL! Visit https://www.mysql.com/certification/ for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: password problem
first: don't reply off-list, a answer on a mailing-list is no invitation for private support! Am 31.07.2015 um 02:34 schrieb Martin Mueller: I read that section but was stopped in my tracks by Log on to your system as the Unix user that the MySQL server runs as (for example, mysql) Because I have no password for ANY thing. read the f**ng https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html - unbelievebale that users these days need anything ready chewed and are too lazy to click on a link and read more than 5 lines Resetting the Root Password: Generic Instructions Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option I used the uninstall routine recommended by Rob Allen, in which you remove the directories /usr/local/mysql as well as /usr/local/mysql* and a lot of other library and etc files. So there is no trace of the old system on my machine. How come a routine installation of mysql then locks up the application. the datadir is *not* removed by any sane installer, dunno where it lives on Apple machines since i banned them 5 years ago for good reasons on a non-OSX i would just type updatedb; locate mysql als root On 7/30/15, 19:22, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same * install and uninstall *never* removes the datadir * users and permissions are in the DB mysql * https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html signature.asc Description: OpenPGP digital signature
Re: password problem
Data directory path mention in cnf is of old mysql. Make a fresh data directory, configure it in configuration file and execute mysqlinstall_db, On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller martinmuel...@northwestern.edu wrote: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same. Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- *Thanks and Regards:* *Nikhil Anand* *+91 9650024197*
Re: password problem
Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same * install and uninstall *never* removes the datadir * users and permissions are in the DB mysql * https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html signature.asc Description: OpenPGP digital signature
RE: Password problem
When connecting from a command line, mysql uses 3 of the columns in the user table to decide whether or not to grant access. These are host, user, and password. Note that in your results below, there is no localhost-newsletter-testPass combination. What the table shows is that clients from any host other than localhost can log in to a mysql client using the newsletter and testPass combination. If you want to login using a client on the same machine that you're running mysql, you need to add another entry to the user table, i.e., GRANT ALL PRIVILIGES ON newsletter.* TO newsletter@localhost IDENTIFIED BY 'testPass' It took me a while to figure that one out, but it's saved me a lot of frustration knowing it now. I guess I don't understand why localhost isn't included in the % wildcard for the host column in this table. Anybody? John Arnold Director, IT Web Strategies 2k3 Technologies 915.439.1660 -Original Message- From: Neil Aggarwal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 11:00 AM To: Mysql list Subject: Password problem Hello: As the root user, I created a new database and user account: CREATE DATABASE newsletter; GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: YES) I checked that mysql has it set-up correctly in the user and db tables by logging in as the root account. select * from user give me this line: | % | newsletter | 61fa73f50740c213 | N | N | N | N | N | N | N | N | N| N | N | N | N | N select * from db gives me this line: | % | newsletter | newsletter | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Any ideas? Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re: Password problem
Nasser wrote: it looks as though you have created the newsletter user with plain text password. mysql will compare the user password against the encrypted password and will fail. Look at the password entry in the results below starting with 61fa If the password had been stored as plain text, it would show as 'testPass'. The only way I've been able to get an unencrypted password into this table (quite unintentionally, I assure you) is to update the table directly as in update user set password='testPass' where user = 'newsletter'; Of course, this was back when I was scratching my head over the same problem below... John Arnold Director, IT Web Strategies 2k3 Technologies 915.439.1660 = Hello: As the root user, I created a new database and user account: CREATE DATABASE newsletter; GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: YES) I checked that mysql has it set-up correctly in the user and db tables by logging in as the root account. select * from user give me this line: | % | newsletter | 61fa73f50740c213 | N | N | N | N | N | N | N | N | N| N | N | N | N | N select * from db gives me this line: | % | newsletter | newsletter | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Any ideas? Yes. See Chapter 4.3.5 of the mysql manual. Note that we must issue GRANT statements for both monty@localhost and monty@%. hth, Doug Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Password problem
On Wed, 15 Jan 2003 11:00:21 -0600, Neil Aggarwal wrote: Hello: As the root user, I created a new database and user account: CREATE DATABASE newsletter; GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: YES) I checked that mysql has it set-up correctly in the user and db tables by logging in as the root account. select * from user give me this line: | % | newsletter | 61fa73f50740c213 | N | N | N | N | N | N | N | N | N| N | N | N | N | N select * from db gives me this line: | % | newsletter | newsletter | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Any ideas? Yes. See Chapter 4.3.5 of the mysql manual. Note that we must issue GRANT statements for both monty@localhost and monty@%. hth, Doug Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Password problem
Neil, GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: YES) I don't know if you have any other entries in the mysql.user / mysql.db tables. If so, there could be another entry for 'newsletter'@'something_else_but_not_%'. Whatever the reason - it's always a good idea to specify user names the classical MySQL way, i. e. 'user'@'machine', and not - as in most other DBMS - only as 'user'. What the manual says about it, is: The simple form user is a synonym for user@%. Details: http://www.mysql.com/doc/en/GRANT.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Neil Aggarwal [EMAIL PROTECTED] To: Mysql list [EMAIL PROTECTED] Sent: Wednesday, January 15, 2003 6:00 PM Subject: Password problem Hello: As the root user, I created a new database and user account: CREATE DATABASE newsletter; GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: YES) I checked that mysql has it set-up correctly in the user and db tables by logging in as the root account. select * from user give me this line: | % | newsletter | 61fa73f50740c213 | N | N | N | N | N | N | N | N | N| N | N | N | N | N select * from db gives me this line: | % | newsletter | newsletter | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Any ideas? Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Password problem
GRANT ALL PRIVILEGES ON newsletter.* TO 'newsletter'@'localhost' IDENTIFIED BY 'testPass'; Neil Aggarwal wrote: Hello: As the root user, I created a new database and user account: CREATE DATABASE newsletter; GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: YES) I checked that mysql has it set-up correctly in the user and db tables by logging in as the root account. select * from user give me this line: | % | newsletter | 61fa73f50740c213 | N | N | N | N | N | N | N | N | N| N | N | N | N | N select * from db gives me this line: | % | newsletter | newsletter | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Any ideas? Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php