Re: access denied error
Sorry to have bothered you. I believe I found the problem. I had a 1 (One) in the password instead of a l (L). it was working from the command prompt, because I was typing it in the same way, but from the application, it was stored. So, basically, I had the password wrong. Thanks, Jesse - Original Message - From: Jim Lyons To: Jesse Cc: MySQL List Sent: Friday, October 10, 2008 8:28 AM Subject: Re: access denied error What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as the same user (myuser)? Do other php applications work, so you know it's not a php-mysql issue? On Fri, Oct 10, 2008 at 6:59 AM, Jesse [EMAIL PROTECTED] wrote: I have a PHP application that I inherited. I have it running on a Ubuntu 8.04 virtual machine. I have set up a user to access the MySQL database, and from the command prompt, I can access it just fine. For instance, from the Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: access denied error
What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as the same user (myuser)? Do other php applications work, so you know it's not a php-mysql issue? On Fri, Oct 10, 2008 at 6:59 AM, Jesse [EMAIL PROTECTED] wrote: I have a PHP application that I inherited. I have it running on a Ubuntu 8.04 virtual machine. I have set up a user to access the MySQL database, and from the command prompt, I can access it just fine. For instance, from the Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
RE: Access denied error
You need to connect as a privileged user. You should delete the anonymous account for security reasons. -Original Message- From: Shane Korosec [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 1:56 AM To: [EMAIL PROTECTED] Subject: Access denied error I have recently installed MySQL my mac running OS X 10.3 and can connect to MySQL using the command: /Library/MySQL/bin/mysql However, once connected, I have tried to create a database and received the error message: ERROR 1044: Access denied for user: '@localhost' to database 'new_database' I have exited and tried connecting using the command: sudo /Library/MySQL/bin/mysql and received the error message: ERROR 1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I am a relatively inexperienced MySQL user, so what can I do so I can manage my database? Any suggestions will be greatly appreciated. _ Hot chart ringtones and polyphonics. Go to http://ninemsn.com.au/mobilemania/default.asp -- 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: Access denied error
Shane Korosec [EMAIL PROTECTED] wrote: I have recently installed MySQL my mac running OS X 10.3 and can connect to MySQL using the command: /Library/MySQL/bin/mysql However, once connected, I have tried to create a database and received the error message: ERROR 1044: Access denied for user: '@localhost' to database 'new_database' You connected as anonymous user ('') that doesn't have appropriate privileges. I have exited and tried connecting using the command: sudo /Library/MySQL/bin/mysql and received the error message: ERROR 1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Use -p option of mysql client to specify root password: http://www.mysql.com/doc/en/Connecting-disconnecting.html I am a relatively inexperienced MySQL user, so what can I do so I can manage my database? Any suggestions will be greatly appreciated. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.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 error
Jeff Roberts [EMAIL PROTECTED] wrote: I have a fresh install of mysql 4.0.11 on a linux box. When I try to open mysql as a [EMAIL PROTECTED], I get the following error: mysql -u [EMAIL PROTECTED] -p db_name Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using password: YES) In this case you try to connect as user with user name '[EMAIL PROTECTED]'. If you want to specify hostname (localhost) you should use -h option: shell mysql -h localhost -u user -p db_name However if just do this, everything is fine: mysql -u user -p db_name Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.11a-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.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 error
Pada Sat, 06 Jul 2002 09:36:27 +0500 (IST) VINOD [EMAIL PROTECTED] menulis : I own a domain with MySQL support. I have created a database lnet_cal on the web and also table yarntype, using PHP Myad- min on the webspace and also granted all access privileges to user lnet_root to the database. can u show us the value from DB mysql regarding this privilege ... use mysql; select * from user where user=lnet_root; select * from db where user=lnet_root; maybe we can help you to analyze your problem ;-) -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 16 days, Queries : 368.249 per second (avg). - 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: Access denied error
VINOD, Saturday, July 06, 2002, 6:49:50 AM, you wrote: V I own a domain with MySQL support. I have created a database V \lnet_cal\ on the web and also table \yarntype\, using PHP Myad- V min on the webspace and also granted all access privileges to V user \lnet_root\ to the database. [skip] V Please suggest me on how to overcome the problem. V The script which I have loaded is as follows. V V ?php [skip] V // (c) V $query= \load data infile \'/home/lnet/public_html/calcutta/yarn V type.txt\' into table yarntype fields terminated by \',\' \ ; V mysql_query($query) or V die(mysql_error()); V // THE ABOVE QUERY HAD DISPLYED THE ERROR AS FOLLOWS V // \Access denied for user: \'lnet_root@localhost\' (Using pass V word: YES)\ You must have FILE privilege to use LOAD DATA INFILE. FILE privilege is a global privilege, but you set up for your user only privileges on the database. GRANT FILE ON *.* TO 'user_name'@'host_name' IDENTIFIED BY 'user_password'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Access denied error
Hi, i am trying to import or export using MYSQL driver. that time it gives following error; Access Denied For User '[EMAIL PROTECTED]' (Using password:YES) did you give all the privileges manually through editing the grant tables, or by the GRANT command (the right command should be something like GRANT all ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'? if you did it manually, did you run 'mysqladmin reload' afterwards? Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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