Re: General Help - ERROR 1045: Access denied for user: 'ackerley@localhost'
Hello Rob, Friday, March 12, 2004, 7:39:47 PM, you wrote: RA> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' > Does that user actually exist within MySQL? I have you used the mysqladmin program and created a user account called ackerley? If not, that's why you can't get in. Try using "root" and giving nothing as the password. If that lets you in, create yourself the ackerley user. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
General Help - ERROR 1045: Access denied for user: 'ackerley@localhost'
Can someone please help me sort this out. System info: Windows XP Apache Server Situation: I have done a fresh install of MySQL 4.0.18 using the windows installer. Everything seems to go fine. I execute the WinMySQLAdmin and it prompts me for a user name and password. I enter this info and click okay. It then opens up the Admin window. The Environment tab main window gives me this message: Not Found Driver 3.51 Not Found Anyhow, I open up my command prompt and change the directory to c:\mysql\bin >From there I type mysql -u ackerley -p Prompts for password and I enter it. Then it beeps and gives me this error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' I am at a loss as to what to do. Please help. Thanks Rob
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Hi! You seems to have just installed mysql. The root user should be able to acces a mysql server from anywhere by default. I don't know why you can connect from localhost, probably you delete the "[EMAIL PROTECTED]"? Anyway it is a good thing to delete the root user after the initial setup, once you have a full rights user created that can manage the db. To do this, loginto mysql as root, and create a full-blown user with everything enable and give it a secure password. like this: mysql -u root -h 192.168.1.10 Now create a full rights user like this grant all privileges on *.* to yournewusername_here@"%" identified by 'passowrdhere' with grant option; flush privileges; This will create a new user with a set of rights comparable with the root's own permissions. Now, with this "superuser" created you can delete the root user use mysql delete from user where User='root'; flush privileges; Now logout, and login again using the new password and the new user! voilà! Best Regards! On Fri, 2004-03-12 at 09:25, Leslie Vance wrote: > Hello, > > I am having a hard time getting Mysql to let [EMAIL PROTECTED] connect. > > I am constantly getting this: > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > when I issue mysql -u root > > I can log in if I use mysql -h 192.168.1.10 -u root mysql > > I guess I have some sort of host thing mixed up but I have tried all sorts > of things out of the list with no avail. I using Redhat 9 and I used the > rpm's distributed by mysql. > > Thanks in advance. > > Les -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Hello, I am having a hard time getting Mysql to let [EMAIL PROTECTED] connect. I am constantly getting this: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when I issue mysql -u root I can log in if I use mysql -h 192.168.1.10 -u root mysql I guess I have some sort of host thing mixed up but I have tried all sorts of things out of the list with no avail. I using Redhat 9 and I used the rpm's distributed by mysql. Thanks in advance. Les -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user: 'ODBC@localhost' (Using password: YES)
Arun, You are back to the same issue. This has nothing to do with MyODBC. The parameters you are passing are not the correct data types. If no username is passed, the user 'ODBC' is supplied. If no host is passed 'localhost' is supplied. The parameter you are passing for the password is being read (not necessarily correctly), but some value is being passed as the password. You need to have someone familiar with your flavor of COBOL show you how to pass the specific data types that the mysql library requires (based upon the MySQL C API). When your are able to pass and confirm the correct data types to the C functions, the process may work (assuming the callout from COBOL works as advertised). Until you can confirm the data types are being correctly interpreted when passed from COBOL to the function, your only going to experience serendipitous success. You need to solve the problem sequentially and the next step here is confirming the data types and parameters being passed from your COBOL code. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP > > - Original Message - > From: "Arunachalam" <[EMAIL PROTECTED]> > To: "KKoTY" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, February 06, 2004 6:21 AM > Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > > I have installed MyODBC 3.51 and created the DSN for my Database. > > > > I want to clarify that; > > If the User name I have given is could not be resolved by > mysal_real_connect, > > then it automatically establish the connection to the server using > > [EMAIL PROTECTED] - right > > > > If so, Is there need to have the user named ODBC in mysql database. > > > > OR > > > > It'll connect automatically using the DSN setting i have specified in > myODBC. > > > > Becaz I don't have the source to check Is COBOL value passed to C > > as such what I have specified? > > > > Please clarify my doubts... > > > > regards, > > Arun. > > > > > > --- KKoTY <[EMAIL PROTECTED]> wrote: > this occures when you ommit the user > name, MYSQL C API uses > > user ODBC as > > > default when you ommit or enter empty string as > > > user name when calling mysql_real_connect() > > > > > > - Original Message - > > > From: "Arunachalam" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Thursday, February 05, 2004 3:38 PM > > > Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > > > > > > > > Hi all, > > > > > > > > Is any one met with the error while connecting to MySQL Server > > > > > > > > *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* > > > > > > > > if so pleass let me know the remedy to resolve this error. > > > > > > > > > > > > I don't have the user named ODBC in my mysql Database. > > > > > > > > my configuration is: > > > > Windows 2000 SP 4. > > > > MySQL Server 4.0.17-max-debug for windows > > > > > > > > The situation I have met this error is when I try to Connect MySQL > > > > from COBOL using the C API provided by MySQL. I have properly link > > > > the *libmysql.lib* file into my COBOL compiler. > > > > > > > > Any suggestion are highly appreciated... > > > > > > > > Thanks. > > > > > > > > regards, > > > > Arun. > > > > > > > > > > > > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > > > > Go to http://in.mobile.yahoo.com > > > > > > > > -- > > > > 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] > > > > > > > > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > > Go to http://in.mobile.yahoo.com > > > > -- > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user: 'ODBC@localhost' (Using password: YES)
I think MyODBC in this situation is irelevant. ODBC reinterpret the SQL language (and is good for some universal data components like ADO,DAO,...), but MySQL C API is native. Also you can't connect by MyODBC using MYSQL C API. So you really didn't forget some parameter??, it seems like. Otherwise try to create user named ODBC, and you will see, also it writes "Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*", so you are using some password, and question is from where this goes, and which password you have to give to user ODBC. I still thing that you must omit some parameter when establishing connection. (But I never tried to make connection from COBOL, I'm just using MYSQL C API from C++) - Original Message - From: "Arunachalam" <[EMAIL PROTECTED]> To: "KKoTY" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 06, 2004 6:21 AM Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > I have installed MyODBC 3.51 and created the DSN for my Database. > > I want to clarify that; > If the User name I have given is could not be resolved by mysal_real_connect, > then it automatically establish the connection to the server using > [EMAIL PROTECTED] - right > > If so, Is there need to have the user named ODBC in mysql database. > > OR > > It'll connect automatically using the DSN setting i have specified in myODBC. > > Becaz I don't have the source to check Is COBOL value passed to C > as such what I have specified? > > Please clarify my doubts... > > regards, > Arun. > > > --- KKoTY <[EMAIL PROTECTED]> wrote: > this occures when you ommit the user name, MYSQL C API uses > user ODBC as > > default when you ommit or enter empty string as > > user name when calling mysql_real_connect() > > > > - Original Message - > > From: "Arunachalam" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, February 05, 2004 3:38 PM > > Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > > > > > Hi all, > > > > > > Is any one met with the error while connecting to MySQL Server > > > > > > *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* > > > > > > if so pleass let me know the remedy to resolve this error. > > > > > > > > > I don't have the user named ODBC in my mysql Database. > > > > > > my configuration is: > > > Windows 2000 SP 4. > > > MySQL Server 4.0.17-max-debug for windows > > > > > > The situation I have met this error is when I try to Connect MySQL > > > from COBOL using the C API provided by MySQL. I have properly link > > > the *libmysql.lib* file into my COBOL compiler. > > > > > > Any suggestion are highly appreciated... > > > > > > Thanks. > > > > > > regards, > > > Arun. > > > > > > > > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > > > Go to http://in.mobile.yahoo.com > > > > > > -- > > > 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] > > > > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > Go to http://in.mobile.yahoo.com > > -- > 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 for user: 'ODBC@localhost' (Using password: YES)
I have installed MyODBC 3.51 and created the DSN for my Database. I want to clarify that; If the User name I have given is could not be resolved by mysal_real_connect, then it automatically establish the connection to the server using [EMAIL PROTECTED] - right If so, Is there need to have the user named ODBC in mysql database. OR It'll connect automatically using the DSN setting i have specified in myODBC. Becaz I don't have the source to check Is COBOL value passed to C as such what I have specified? Please clarify my doubts... regards, Arun. --- KKoTY <[EMAIL PROTECTED]> wrote: > this occures when you ommit the user name, MYSQL C API uses user ODBC as > default when you ommit or enter empty string as > user name when calling mysql_real_connect() > > - Original Message - > From: "Arunachalam" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, February 05, 2004 3:38 PM > Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > > Hi all, > > > > Is any one met with the error while connecting to MySQL Server > > > > *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* > > > > if so pleass let me know the remedy to resolve this error. > > > > > > I don't have the user named ODBC in my mysql Database. > > > > my configuration is: > > Windows 2000 SP 4. > > MySQL Server 4.0.17-max-debug for windows > > > > The situation I have met this error is when I try to Connect MySQL > > from COBOL using the C API provided by MySQL. I have properly link > > the *libmysql.lib* file into my COBOL compiler. > > > > Any suggestion are highly appreciated... > > > > Thanks. > > > > regards, > > Arun. > > > > > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > > Go to http://in.mobile.yahoo.com > > > > -- > > 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] > Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user: 'ODBC@localhost' (Using password: YES)
this occures when you ommit the user name, MYSQL C API uses user ODBC as default when you ommit or enter empty string as user name when calling mysql_real_connect() - Original Message - From: "Arunachalam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 05, 2004 3:38 PM Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > Hi all, > > Is any one met with the error while connecting to MySQL Server > > *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* > > if so pleass let me know the remedy to resolve this error. > > > I don't have the user named ODBC in my mysql Database. > > my configuration is: > Windows 2000 SP 4. > MySQL Server 4.0.17-max-debug for windows > > The situation I have met this error is when I try to Connect MySQL > from COBOL using the C API provided by MySQL. I have properly link > the *libmysql.lib* file into my COBOL compiler. > > Any suggestion are highly appreciated... > > Thanks. > > regards, > Arun. > > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > Go to http://in.mobile.yahoo.com > > -- > 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 for user: 'ODBC@localhost' (Using password: YES)
Arunachalam wrote: Hi all, Is any one met with the error while connecting to MySQL Server *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* OK, you tried to log into mysql as [EMAIL PROTECTED], using a password. if so pleass let me know the remedy to resolve this error. I don't have the user named ODBC in my mysql Database. Well, there's your problem. You can't log in as [EMAIL PROTECTED] if that user doesn't exist. You need to either create that user in mysql, or change your connect to use a user who is already in mysql. my configuration is: Windows 2000 SP 4. MySQL Server 4.0.17-max-debug for windows The situation I have met this error is when I try to Connect MySQL from COBOL using the C API provided by MySQL. I have properly link the *libmysql.lib* file into my COBOL compiler. Any suggestion are highly appreciated... Thanks. regards, Arun. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user: 'ODBC@localhost' (Using password: YES)
You have attempted to login with out supplying a username. Try logging in like: mysql -u -p >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 8:38:13 AM, Arunachalam <[EMAIL PROTECTED]> wrote regarding Access denied for user: '[EMAIL PROTECTED]' (Using password: YES): > Hi all, > Is any one met with the error while connecting to MySQL Server > *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* > if so pleass let me know the remedy to resolve this error. > I don't have the user named ODBC in my mysql Database. > my configuration is: > Windows 2000 SP 4. > MySQL Server 4.0.17-max-debug for windows > The situation I have met this error is when I try to Connect MySQL > from COBOL using the C API provided by MySQL. I have properly link > the *libmysql.lib* file into my COBOL compiler. > Any suggestion are highly appreciated... > Thanks. > regards, > Arun. > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > Go to http://in.mobile.yahoo.com > -- > 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]
Access denied for user: 'ODBC@localhost' (Using password: YES)
Hi all, Is any one met with the error while connecting to MySQL Server *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* if so pleass let me know the remedy to resolve this error. I don't have the user named ODBC in my mysql Database. my configuration is: Windows 2000 SP 4. MySQL Server 4.0.17-max-debug for windows The situation I have met this error is when I try to Connect MySQL from COBOL using the C API provided by MySQL. I have properly link the *libmysql.lib* file into my COBOL compiler. Any suggestion are highly appreciated... Thanks. regards, Arun. Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
I figured it out. Actualy silly me forgot to add the password() function how embarising. :) -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
> now allowing clients to login but I'm not sure what would cuse it not to > allow root to change the password, I dubble and triple checked my entry > but still nothing happens. Once I login to root I do the following > > mysql> use mysql > mysql> UPDATE user SET Password= ('x') > -> WHERE user='root'; > > Here is the response I get > > Query OK, 0 rows affected (0.01 sec) > Rows matched: 4 Changed: 0 Warnings: 0 > > Not sure why nothing is changed? Anyideas. Might root not have the > privlage? if so, how might I be able to change the password? > -- > Jerry M. Howell II > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > Just disregard that last post. I tried to change the password to the same password. Still, it's not letting root login with a set password. -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote: > Jerry, > > Don't forget that MySQL authenticates an entity, which is based on the user > name and host. For example, on my MySQL boxes root can only login from the > localhost. If I attempt to login with root from another host, I am denied > access. > True, by default it does, I ssh'ed into the mysql server and did it that way. Actualy it apears that now it's not changeing the password. It's now allowing clients to login but I'm not sure what would cuse it not to allow root to change the password, I dubble and triple checked my entry but still nothing happens. Once I login to root I do the following mysql> use mysql mysql> UPDATE user SET Password= ('x') -> WHERE user='root'; Here is the response I get Query OK, 0 rows affected (0.01 sec) Rows matched: 4 Changed: 0 Warnings: 0 Not sure why nothing is changed? Anyideas. Might root not have the privlage? if so, how might I be able to change the password? -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
Jerry, Don't forget that MySQL authenticates an entity, which is based on the user name and host. For example, on my MySQL boxes root can only login from the localhost. If I attempt to login with root from another host, I am denied access. Regards, Adam -Original Message- From: Jerry M. Howell II [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 1:24 PM To: [EMAIL PROTECTED] Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Hey there all, Here is the problem I am haveing and was wondering if anyone can help me here. I was getting the following error when loging into mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) After searching for an answer I found the answer was to re-start using --skip-grant-tables and change the password then restart mysql useing the normal startup script. This worked well. The next step is where I run into problems. After I log into mysql in the normal mode and reset the password I go back to ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:YES). Also, other users are reporting that they can't access thier databases. Based on what I am seeing here I am able to login to mysql as root as long as there is no password. Once I set a password it wont let me connect. Also found that users can't login to the databases. Does anyone have any idea whats going on and how I might be able to resove this problem? Thanks, -- Jerry M. Howell II -- 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]
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Hey there all, Here is the problem I am haveing and was wondering if anyone can help me here. I was getting the following error when loging into mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) After searching for an answer I found the answer was to re-start using --skip-grant-tables and change the password then restart mysql useing the normal startup script. This worked well. The next step is where I run into problems. After I log into mysql in the normal mode and reset the password I go back to ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:YES). Also, other users are reporting that they can't access thier databases. Based on what I am seeing here I am able to login to mysql as root as long as there is no password. Once I set a password it wont let me connect. Also found that users can't login to the databases. Does anyone have any idea whats going on and how I might be able to resove this problem? Thanks, -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied for User: root@127.0.0.1(Using password: NO)
For Mysql, 127.0.0.1 is not the same as localhost. Localhost refers to the socket file on the operating system, and is faster than 127.0.0.1. Use 'root'@'127.0.0.1' in your grant statements. Ola Ogunneye wrote: Please somebody help me. I have installed MySql 4.0.13 and it works up until I try to apply security settings to the root user at localhost. I see the mysql database and I check the privileges and there is no password for the roo user. But when I assign a password to make it secure, I can run phpmyadmin, but I cannot get into the database anymore. All I get is: MySql Said: Access Denied for user: [EMAIL PROTECTED] (Using password: NO) This situation has happened 3 times and I had to reinstall MySql and start from scratch. Can someone please point me in the right direction, this is my first try and it has been quite a serious learning experience. Thank you in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access Denied for User: root@127.0.0.1(Using password: NO)
You can try one or the other mysql -h localhost -u root -ppasswd db or mysql -h `uname -n` -u root -ppasswd db in solaris On Mon, 30 Jun 2003, Twibell, Cory L wrote: > Did you flush the privileges after you gave root a password? > The error you get is a result of not using a password to login. > > -Original Message- > From: Ola Ogunneye [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 6:05 PM > To: [EMAIL PROTECTED] > Subject: Access Denied for User: [EMAIL PROTECTED](Using password: NO) > > > Please somebody help me. > > I have installed MySql 4.0.13 and it works up until I try to apply security > settings to the root user at localhost. > > I see the mysql database and I check the privileges and there is no password > for the roo user. But when I assign a password to make it secure, I can run > phpmyadmin, but I cannot get into the database anymore. All I get is: > > MySql Said: > Access Denied for user: [EMAIL PROTECTED] (Using password: NO) > > This situation has happened 3 times and I had to reinstall MySql and start > from scratch. > > Can someone please point me in the right direction, this is my first try and > it has been quite a serious learning experience. > > Thank you in advance. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access Denied for User: root@127.0.0.1(Using password: NO)
Did you flush the privileges after you gave root a password? The error you get is a result of not using a password to login. -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 6:05 PM To: [EMAIL PROTECTED] Subject: Access Denied for User: [EMAIL PROTECTED](Using password: NO) Please somebody help me. I have installed MySql 4.0.13 and it works up until I try to apply security settings to the root user at localhost. I see the mysql database and I check the privileges and there is no password for the roo user. But when I assign a password to make it secure, I can run phpmyadmin, but I cannot get into the database anymore. All I get is: MySql Said: Access Denied for user: [EMAIL PROTECTED] (Using password: NO) This situation has happened 3 times and I had to reinstall MySql and start from scratch. Can someone please point me in the right direction, this is my first try and it has been quite a serious learning experience. Thank you in advance. -- 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]
Access Denied for User: root@127.0.0.1(Using password: NO)
Please somebody help me. I have installed MySql 4.0.13 and it works up until I try to apply security settings to the root user at localhost. I see the mysql database and I check the privileges and there is no password for the roo user. But when I assign a password to make it secure, I can run phpmyadmin, but I cannot get into the database anymore. All I get is: MySql Said: Access Denied for user: [EMAIL PROTECTED] (Using password: NO) This situation has happened 3 times and I had to reinstall MySql and start from scratch. Can someone please point me in the right direction, this is my first try and it has been quite a serious learning experience. Thank you in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user: '@localhost' to database 'mysql'
don't piggyback on other people's threads. you can start your own for free. # [EMAIL PROTECTED] / 2003-06-19 13:23:04 -0700: > I ran a command which was part of the installation process for some php > accounting software. > > update user set host='%' where host='localhost' and user='root'; that's quite a bug there, and you should report it to the authors. > Figured it just let root log in from anywhere. almost. it lets root in from anywhere *except* localhost. > Access denied for user: '@localhost' to database 'mysql' right. -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied for user: '@localhost' to database 'mysql'
I ran a command which was part of the installation process for some php accounting software. update user set host='%' where host='localhost' and user='root'; Figured it just let root log in from anywhere. Dunno if that is what caused the problem or not. But now root can't access anything in mysql anymore. When I do \s it shows the user as '[EMAIL PROTECTED]'. But when I try to look at tables in mysql it thinks the user is only '@localhost'. The error I get is: Access denied for user: '@localhost' to database 'mysql' Anyone know wassup? Thanks. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DBCP and ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 abjett wrote: | Can anyone tell me what I am doing wrong or need to do with the following. | | Using MySQL 4.0.11 gamma, win 2000, j2sdk1.4.1_01 and Tomcat 4.1. | | Under mysql, the statement: GRANT ALL PRIVILEGES ON *.* TO | [EMAIL PROTECTED] IDENTIFIED BY 'javadude' WITH GRANT OPTION; | Produces this error: ERROR 1045 Access Denied for user:'@127.0.0.1' | (Using password:NO). | | I am attempting to setup DBCP and get the above message while trying to | setup the user. (The document for the DBCP setup is at: | http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how | to.html, see "MySQL DBCP Example".). I am at step 1 of this process and | without a user/password the code apparently doesn't work. | | Thanks, | Bob Have you read the README that comes with Connector/J? This is covered in the 'Troubleshooting' section. -Mark -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+jf5ElyjUJM+7nP4RAnoJAKCEaszoDCu/P7QeYs4IpNU49A9ubgCfZfGA /mN+eRXZy/VwTUu9apBwsHY= =kD3N -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DBCP and ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
Can anyone tell me what I am doing wrong or need to do with the following. Using MySQL 4.0.11 gamma, win 2000, j2sdk1.4.1_01 and Tomcat 4.1. Under mysql, the statement: GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'javadude' WITH GRANT OPTION; Produces this error: ERROR 1045 Access Denied for user:'@127.0.0.1' (Using password:NO). I am attempting to setup DBCP and get the above message while trying to setup the user. (The document for the DBCP setup is at: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html, see "MySQL DBCP Example".). I am at step 1 of this process and without a user/password the code apparently doesn't work. Thanks, Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user:
Both ip's are in the user table along with the % wildcard. -- Steve (egrep) On Fri, 7 Mar 2003, gerald_clark wrote: > You grant IP address does not match the IP address of the client failing > the connection. > > Steve Pirk wrote: > > >That was a great suggestion (getting rid of the > >"blank" user), but alas, it did not work. Here > >are the three examples: (first one fail because the > >blank user was removed) > > > >[EMAIL PROTECTED]:~$ mysql > >ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > > >[EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p > >Enter password: > >Welcome to the MySQL monitor. Commands end with ; or \g. > >Your MySQL connection id is 5711 to server version: 3.23.55 > > > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > >mysql> quit > >Bye > > > >[EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p > >Enter password: > >ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > >password: YES) > > > >-- > >Steve (egrep) > > > >On Thu, 6 Mar 2003, Paul DuBois wrote: > > > > > > > >>At 11:07 +1100 3/7/03, Ben Balbo wrote: > >> > >> > >>>Hi Steve, > >>> > >>>Really silly question, but you are reloading the tables once you > >>>change the grants, aren't you :-) > >>> > >>>mysqladmin -p reload > >>> > >>>B. > >>> > >>> > >>Yep, it's silly. :-) Because GRANT automatically refreshes the > >>in-memory copies of the grant tables. > >> > >>Steve, try this: > >> > >>mysql> DELETE FROM mysql.user WHERE User = ''; > >>mysql> FLUSH PRIVILEGES; > >> > >>(FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies > >>the grant tables, and you have to tell the server to refresh the in-memory > >>copies). > >> > >>Then try to connect again. Bet it'll work. > >> > >> > >> > >>>In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > >>> > >>> > >>> > >>>> Mysql version 3.23.55 Slackware linux 8.0 > >>>> Mysql version 3.23.55 OpenBSD > >>>> > >>>> > >>>> I have tried 3 versions of mysql on linux and > >>>> on OpenBSD. I have even tried compiling on linux > >>>> from the source tarball. > >>>> > >>>> > >>>> Without the GRANT privs to allow network access: > >>>> > >>>> > >>>mysql>> GRANT ALL PRIVILEGES ON db.* > >>> > >>> > >>>> -> TO user@'192.58.197.0/255.255.255.0'; > >>>> (example), I would get a "you are not allowed to connect" > >>>> error. Once I applied the grant to the user: > >>>> > >>>> > >>>mysql>> GRANT ALL PRIVILEGES ON db.* > >>> > >>> > >>>> -> TO user@'%' > >>>> the users table shows: > >>>> | Host| User | > >>>> --- > >>>> | % | user | > >>>> > >>>> > >>>> If I coonect to the database without a host, or > >>>> with host set to localhost, I can connect fine. If > >>>> I connect from another machine, or just use the DNS > >>>> name on the local machine, I get: > >>>> mysql -h 192.168.1.24 -u test -p > >>>> > >>>> > >>>> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > >>>> password: YES) > >>>> > >>>> > >>>> I have even tried connecting using the IP address. I have poured > >>>> over the docs, and have tried all the scenarios of add hostnames > >>>> to /etc/hosts etc. I even complied from source (glibc problem). > >>>> No luck at all... Any ideas? I really need network access to the > >>>> database. > >>>> -- > >>>> > >>>> > >>> > Steve (egrep) > >>> > >>> > >>- > >>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: ERROR 1045: Access denied for user:
You grant IP address does not match the IP address of the client failing the connection. Steve Pirk wrote: That was a great suggestion (getting rid of the "blank" user), but alas, it did not work. Here are the three examples: (first one fail because the blank user was removed) [EMAIL PROTECTED]:~$ mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5711 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye [EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -- Steve (egrep) On Thu, 6 Mar 2003, Paul DuBois wrote: At 11:07 +1100 3/7/03, Ben Balbo wrote: Hi Steve, Really silly question, but you are reloading the tables once you change the grants, aren't you :-) mysqladmin -p reload B. Yep, it's silly. :-) Because GRANT automatically refreshes the in-memory copies of the grant tables. Steve, try this: mysql> DELETE FROM mysql.user WHERE User = ''; mysql> FLUSH PRIVILEGES; (FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies the grant tables, and you have to tell the server to refresh the in-memory copies). Then try to connect again. Bet it'll work. In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. Mysql version 3.23.55 Slackware linux 8.0 Mysql version 3.23.55 OpenBSD I have tried 3 versions of mysql on linux and on OpenBSD. I have even tried compiling on linux from the source tarball. Without the GRANT privs to allow network access: mysql>> GRANT ALL PRIVILEGES ON db.* -> TO user@'192.58.197.0/255.255.255.0'; (example), I would get a "you are not allowed to connect" error. Once I applied the grant to the user: mysql>> GRANT ALL PRIVILEGES ON db.* -> TO user@'%' the users table shows: | Host| User | --- | % | user | If I coonect to the database without a host, or with host set to localhost, I can connect fine. If I connect from another machine, or just use the DNS name on the local machine, I get: mysql -h 192.168.1.24 -u test -p ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have even tried connecting using the IP address. I have poured over the docs, and have tried all the scenarios of add hostnames to /etc/hosts etc. I even complied from source (glibc problem). No luck at all... Any ideas? I really need network access to the database. -- > Steve (egrep) - 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: ERROR 1045: Access denied for user:
I just installed the standard-4.0.11 binary and the same problem exists. Error 1130: this host is not allowed to connect. Run the grant and flush privs. Access denied... -- Steve (egrep) On Fri, 7 Mar 2003, Steve Pirk wrote: > That was a great suggestion (getting rid of the > "blank" user), but alas, it did not work. Here > are the three examples: (first one fail because the > blank user was removed) > > [EMAIL PROTECTED]:~$ mysql > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > [EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 5711 to server version: 3.23.55 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> quit > Bye > > [EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p > Enter password: > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES) > > -- > Steve (egrep) > > On Thu, 6 Mar 2003, Paul DuBois wrote: > > > At 11:07 +1100 3/7/03, Ben Balbo wrote: > > >Hi Steve, > > > > > >Really silly question, but you are reloading the tables once you > > >change the grants, aren't you :-) > > > > > >mysqladmin -p reload > > > > > >B. > > > > Yep, it's silly. :-) Because GRANT automatically refreshes the > > in-memory copies of the grant tables. > > > > Steve, try this: > > > > mysql> DELETE FROM mysql.user WHERE User = ''; > > mysql> FLUSH PRIVILEGES; > > > > (FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies > > the grant tables, and you have to tell the server to refresh the in-memory > > copies). > > > > Then try to connect again. Bet it'll work. > > > > > > > >In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > > > > > >> Mysql version 3.23.55 Slackware linux 8.0 > > >> Mysql version 3.23.55 OpenBSD > > > > > >> I have tried 3 versions of mysql on linux and > > >> on OpenBSD. I have even tried compiling on linux > > >> from the source tarball. > > > > > >> Without the GRANT privs to allow network access: > > >mysql>> GRANT ALL PRIVILEGES ON db.* > > >> -> TO user@'192.58.197.0/255.255.255.0'; > > >> (example), I would get a "you are not allowed to connect" > > >> error. Once I applied the grant to the user: > > >mysql>> GRANT ALL PRIVILEGES ON db.* > > >> -> TO user@'%' > > >> the users table shows: > > >> | Host| User | > > >> --- > > >> | % | user | > > > > > >> If I coonect to the database without a host, or > > >> with host set to localhost, I can connect fine. If > > >> I connect from another machine, or just use the DNS > > >> name on the local machine, I get: > > >> mysql -h 192.168.1.24 -u test -p > > > > > >> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > >> password: YES) > > > > > >> I have even tried connecting using the IP address. I have poured > > >> over the docs, and have tried all the scenarios of add hostnames > > >> to /etc/hosts etc. I even complied from source (glibc problem). > > >> No luck at all... Any ideas? I really need network access to the > > >> database. > > >> -- > > > > Steve (egrep) > > > > > > - > > 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: ERROR 1045: Access denied for user:
That was a great suggestion (getting rid of the "blank" user), but alas, it did not work. Here are the three examples: (first one fail because the blank user was removed) [EMAIL PROTECTED]:~$ mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5711 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye [EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -- Steve (egrep) On Thu, 6 Mar 2003, Paul DuBois wrote: > At 11:07 +1100 3/7/03, Ben Balbo wrote: > >Hi Steve, > > > >Really silly question, but you are reloading the tables once you > >change the grants, aren't you :-) > > > >mysqladmin -p reload > > > >B. > > Yep, it's silly. :-) Because GRANT automatically refreshes the > in-memory copies of the grant tables. > > Steve, try this: > > mysql> DELETE FROM mysql.user WHERE User = ''; > mysql> FLUSH PRIVILEGES; > > (FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies > the grant tables, and you have to tell the server to refresh the in-memory > copies). > > Then try to connect again. Bet it'll work. > > > > >In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > > > >> Mysql version 3.23.55 Slackware linux 8.0 > >> Mysql version 3.23.55 OpenBSD > > > >> I have tried 3 versions of mysql on linux and > >> on OpenBSD. I have even tried compiling on linux > >> from the source tarball. > > > >> Without the GRANT privs to allow network access: > >mysql>> GRANT ALL PRIVILEGES ON db.* > >> -> TO user@'192.58.197.0/255.255.255.0'; > >> (example), I would get a "you are not allowed to connect" > >> error. Once I applied the grant to the user: > >mysql>> GRANT ALL PRIVILEGES ON db.* > >> -> TO user@'%' > >> the users table shows: > >> | Host | User | > >> --- > >> | % | user | > > > >> If I coonect to the database without a host, or > >> with host set to localhost, I can connect fine. If > >> I connect from another machine, or just use the DNS > >> name on the local machine, I get: > >> mysql -h 192.168.1.24 -u test -p > > > >> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > >> password: YES) > > > >> I have even tried connecting using the IP address. I have poured > >> over the docs, and have tried all the scenarios of add hostnames > >> to /etc/hosts etc. I even complied from source (glibc problem). > >> No luck at all... Any ideas? I really need network access to the > >> database. > >> -- > > > Steve (egrep) > > > - > 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: ERROR 1045: Access denied for user:
At 11:07 +1100 3/7/03, Ben Balbo wrote: Hi Steve, Really silly question, but you are reloading the tables once you change the grants, aren't you :-) mysqladmin -p reload B. Yep, it's silly. :-) Because GRANT automatically refreshes the in-memory copies of the grant tables. Steve, try this: mysql> DELETE FROM mysql.user WHERE User = ''; mysql> FLUSH PRIVILEGES; (FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies the grant tables, and you have to tell the server to refresh the in-memory copies). Then try to connect again. Bet it'll work. In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. Mysql version 3.23.55 Slackware linux 8.0 Mysql version 3.23.55 OpenBSD I have tried 3 versions of mysql on linux and on OpenBSD. I have even tried compiling on linux from the source tarball. Without the GRANT privs to allow network access: mysql>> GRANT ALL PRIVILEGES ON db.* -> TO user@'192.58.197.0/255.255.255.0'; (example), I would get a "you are not allowed to connect" error. Once I applied the grant to the user: mysql>> GRANT ALL PRIVILEGES ON db.* -> TO user@'%' the users table shows: | Host| User | --- | % | user | If I coonect to the database without a host, or with host set to localhost, I can connect fine. If I connect from another machine, or just use the DNS name on the local machine, I get: mysql -h 192.168.1.24 -u test -p ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have even tried connecting using the IP address. I have poured over the docs, and have tried all the scenarios of add hostnames to /etc/hosts etc. I even complied from source (glibc problem). No luck at all... Any ideas? I really need network access to the database. -- > Steve (egrep) - 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: ERROR 1045: Access denied for user:
Yep, tried that... but I will try it again... -- Steve (egrep) On Thu, 6 Mar 2003, Roger Davis wrote: > Or > > mysql>> flush privileges; > > Roger > > -Original Message- > From: Ben Balbo [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 06, 2003 7:08 PM > To: MySQL List > Subject: Re: ERROR 1045: Access denied for user: > > > Hi Steve, > > Really silly question, but you are reloading the tables once you > change the grants, aren't you :-) > > mysqladmin -p reload > > B. > > In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > > > Mysql version 3.23.55 Slackware linux 8.0 > > Mysql version 3.23.55 OpenBSD > > > I have tried 3 versions of mysql on linux and > > on OpenBSD. I have even tried compiling on linux > > from the source tarball. > > > Without the GRANT privs to allow network access: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'192.58.197.0/255.255.255.0'; > > (example), I would get a "you are not allowed to connect" > > error. Once I applied the grant to the user: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'%' > > the users table shows: > > | Host| User | > > --- > > | % | user | > > > If I coonect to the database without a host, or > > with host set to localhost, I can connect fine. If > > I connect from another machine, or just use the DNS > > name on the local machine, I get: > > mysql -h 192.168.1.24 -u test -p > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > password: YES) > > > I have even tried connecting using the IP address. I have poured > > over the docs, and have tried all the scenarios of add hostnames > > to /etc/hosts etc. I even complied from source (glibc problem). > > No luck at all... Any ideas? I really need network access to the > > database. > > -- > > Steve (egrep) > > > > - > > 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 > - 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: ERROR 1045: Access denied for user:
Tried this... no go... The wierd part, is that localhost works fine, but I cannot connect locally if I use the hostname. Thanks for the help! (maybe I should go back to an old version of mysql :-) -- Steve (egrep) On Fri, 7 Mar 2003, Ben Balbo wrote: > Hi Steve, > > Really silly question, but you are reloading the tables once you > change the grants, aren't you :-) > > mysqladmin -p reload > > B. > > In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > > > Mysql version 3.23.55 Slackware linux 8.0 > > Mysql version 3.23.55 OpenBSD > > > I have tried 3 versions of mysql on linux and > > on OpenBSD. I have even tried compiling on linux > > from the source tarball. > > > Without the GRANT privs to allow network access: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'192.58.197.0/255.255.255.0'; > > (example), I would get a "you are not allowed to connect" > > error. Once I applied the grant to the user: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'%' > > the users table shows: > > | Host| User | > > --- > > | % | user | > > > If I coonect to the database without a host, or > > with host set to localhost, I can connect fine. If > > I connect from another machine, or just use the DNS > > name on the local machine, I get: > > mysql -h 192.168.1.24 -u test -p > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > password: YES) > > > I have even tried connecting using the IP address. I have poured > > over the docs, and have tried all the scenarios of add hostnames > > to /etc/hosts etc. I even complied from source (glibc problem). > > No luck at all... Any ideas? I really need network access to the > > database. > > -- > > Steve (egrep) > > > > - > > 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: ERROR 1045: Access denied for user:
Did not see a reference to reloading tables in the docs. This is just weird enough for me to vpn in and try again :-) Thanks! -- Steve (egrep) On Fri, 7 Mar 2003, Ben Balbo wrote: > Hi Steve, > > Really silly question, but you are reloading the tables once you > change the grants, aren't you :-) > > mysqladmin -p reload > > B. > > In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > > > Mysql version 3.23.55 Slackware linux 8.0 > > Mysql version 3.23.55 OpenBSD > > > I have tried 3 versions of mysql on linux and > > on OpenBSD. I have even tried compiling on linux > > from the source tarball. > > > Without the GRANT privs to allow network access: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'192.58.197.0/255.255.255.0'; > > (example), I would get a "you are not allowed to connect" > > error. Once I applied the grant to the user: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'%' > > the users table shows: > > | Host| User | > > --- > > | % | user | > > > If I coonect to the database without a host, or > > with host set to localhost, I can connect fine. If > > I connect from another machine, or just use the DNS > > name on the local machine, I get: > > mysql -h 192.168.1.24 -u test -p > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > password: YES) > > > I have even tried connecting using the IP address. I have poured > > over the docs, and have tried all the scenarios of add hostnames > > to /etc/hosts etc. I even complied from source (glibc problem). > > No luck at all... Any ideas? I really need network access to the > > database. > > -- > > Steve (egrep) > > > > - > > 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: ERROR 1045: Access denied for user:
Or mysql>> flush privileges; Roger -Original Message- From: Ben Balbo [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 7:08 PM To: MySQL List Subject: Re: ERROR 1045: Access denied for user: Hi Steve, Really silly question, but you are reloading the tables once you change the grants, aren't you :-) mysqladmin -p reload B. In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > Mysql version 3.23.55 Slackware linux 8.0 > Mysql version 3.23.55 OpenBSD > I have tried 3 versions of mysql on linux and > on OpenBSD. I have even tried compiling on linux > from the source tarball. > Without the GRANT privs to allow network access: mysql>> GRANT ALL PRIVILEGES ON db.* > -> TO user@'192.58.197.0/255.255.255.0'; > (example), I would get a "you are not allowed to connect" > error. Once I applied the grant to the user: mysql>> GRANT ALL PRIVILEGES ON db.* > -> TO user@'%' > the users table shows: > | Host| User | > --- > | % | user | > If I coonect to the database without a host, or > with host set to localhost, I can connect fine. If > I connect from another machine, or just use the DNS > name on the local machine, I get: > mysql -h 192.168.1.24 -u test -p > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES) > I have even tried connecting using the IP address. I have poured > over the docs, and have tried all the scenarios of add hostnames > to /etc/hosts etc. I even complied from source (glibc problem). > No luck at all... Any ideas? I really need network access to the > database. > -- > Steve (egrep) > - > 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: ERROR 1045: Access denied for user:
Hi Steve, Really silly question, but you are reloading the tables once you change the grants, aren't you :-) mysqladmin -p reload B. In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > Mysql version 3.23.55 Slackware linux 8.0 > Mysql version 3.23.55 OpenBSD > I have tried 3 versions of mysql on linux and > on OpenBSD. I have even tried compiling on linux > from the source tarball. > Without the GRANT privs to allow network access: mysql>> GRANT ALL PRIVILEGES ON db.* > -> TO user@'192.58.197.0/255.255.255.0'; > (example), I would get a "you are not allowed to connect" > error. Once I applied the grant to the user: mysql>> GRANT ALL PRIVILEGES ON db.* > -> TO user@'%' > the users table shows: > | Host| User | > --- > | % | user | > If I coonect to the database without a host, or > with host set to localhost, I can connect fine. If > I connect from another machine, or just use the DNS > name on the local machine, I get: > mysql -h 192.168.1.24 -u test -p > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES) > I have even tried connecting using the IP address. I have poured > over the docs, and have tried all the scenarios of add hostnames > to /etc/hosts etc. I even complied from source (glibc problem). > No luck at all... Any ideas? I really need network access to the > database. > -- > Steve (egrep) > - > 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
ERROR 1045: Access denied for user:
Mysql version 3.23.55 Slackware linux 8.0 Mysql version 3.23.55 OpenBSD I have tried 3 versions of mysql on linux and on OpenBSD. I have even tried compiling on linux from the source tarball. Without the GRANT privs to allow network access: mysql> GRANT ALL PRIVILEGES ON db.* -> TO user@'192.58.197.0/255.255.255.0'; (example), I would get a "you are not allowed to connect" error. Once I applied the grant to the user: mysql> GRANT ALL PRIVILEGES ON db.* -> TO user@'%' the users table shows: | Host| User | --- | % | user | If I coonect to the database without a host, or with host set to localhost, I can connect fine. If I connect from another machine, or just use the DNS name on the local machine, I get: mysql -h 192.168.1.24 -u test -p ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have even tried connecting using the IP address. I have poured over the docs, and have tried all the scenarios of add hostnames to /etc/hosts etc. I even complied from source (glibc problem). No luck at all... Any ideas? I really need network access to the database. -- Steve (egrep) - 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
Strange [Access denied for user], please help !!!
Hi all, I've some problem with my Mysql servers since the beginning of last week :( I've upgrade mysql from 3.23.53a to 3.23.54a and i still have same errors :( I've got plenty of error like this : Failed to connect to database: Error: Access denied for user: ´[EMAIL PROTECTED]´ to database ´DB1´ MySQL server has gone away I connect from web servers which are on the same 100Mb LAN that mysql servers. I try during a ping during at least 2 hours and i didn't find anything, 0 packet loss ... OS : linux I tried check table extended on the table and status is ok, I try a new flush privileges and this didn't change anything ... Thanks. David Original message : Subject : [Error] Mysql server has gone away && 3.23.53a Hi all, I've some problem with my Mysql servers since the beginning of this week. I've got plenty of error like this : Failed to connect to database: Error: Access denied for user: ´[EMAIL PROTECTED]´ to database ´DB1´ MySQL server has gone away Error Nø1, please contact webmaster ... In fact, clients are C cgi compiled with libmysql ( in this package MySQL-devel-3.23.49-1.i386.rpm ) The Cgi is ok and have worked well since several mounths. Error Nø1 : connection mysql ok, can't execute my query It seems that mysql disconnect me before i can execute my query. But query is just after the connection in the code ... :( Server : Linux Redhat 2 * PIII 1 Ghz 1Go ram Scsi raid 5 mysql-3.23.53a-pc-linux-gnu-i686.tar.gz ( binary ) As you can see, i connect to my server via a 100Mb LAN. The LAN is ok, all ethernet card are 100Mb Full Duplex without any collision or packet dropped. Exemple : RX packets:259950587 errors:0 dropped:0 overruns:0 frame:0 TX packets:1809122347 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 lg file transmission:100 RX bytes:3130833186 (2985.7 Mb) TX bytes:1637489037 (1561.6 Mb) Here's the my.cnf : # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable= key_buffer=256M set-variable= back_log=150 set-variable= record_buffer=1M set-variable= sort_buffer=1M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= max_connections=700 set-variable= max_connect_errors=100 set-variable= table_cache=512 set-variable= net_read_timeout=180 set-variable= net_write_timeout=180 set-variable= wait_timeout=3600 set-variable= thread_concurrency=4 I can't see anything in the error log. Mysqld is still alive and still responding 99% of the time. Status : Threads: 3 Questions: 3065350 Slow queries: 46 Opens: 91 Flush tables: 1 Open tables: 66 Queries per second avg: 9.052 Show Status : Aborted_clients 4401 Aborted_connects374 Bytes_received332129641 Bytes_sent 1691254415 [...] Created_tmp_disk_tables 0 Created_tmp_tables211 Created_tmp_files 1290 Handler_delete | 11135 | Handler_read_first | 226| Handler_read_key | 2005755| Handler_read_next| 1714626349 | Handler_read_prev| 0 | Handler_read_rnd | 2613047| Handler_read_rnd_next| 62634691 | Handler_update | 357300 | Handler_write| 304440 | Key_blocks_used | 62869 | Key_read_requests| 97082717 | Key_reads| 60114 | Key_write_requests | 487582 | Key_writes | 392106 | Max_used_connections | 23 | Not_flushed_key_blocks | 0 | Not_flushed_delayed_rows | 0 | Open_tables | 66 | Open_files | 102| Open_streams | 0 | Opened_tables| 91 Questions| 3065612| Select_full_join | 0 | Select_full_range_join | 0 | Select_range | 600| Select_range_check | 0 | Select_scan | 51701 | Slave_running| OFF| Slave_open_temp_tables | 0 | Slow_launch_threads | 0 | Slow_queries | 46 | Sort_merge_passes| 645| Sort_range | 99887 | Sort_rows| 2613047| Sort_scan| 20030 | Table_locks_immediate| 1841001| Table_locks_waited | 1977 | Threads_cached | 0 | Threads_created | 1226346| Threads_connected| 2 | Threads_running | 1 | Uptime | 338664 Extract of the mysql.db table : 192.168.10.4 | DB1 | JForvC15 | Y ( select priv ... ) Thanks to all. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this
re: Re: access denied for user: root@localhost
Jack, Tuesday, November 05, 2002, 6:08:58 PM, you wrote: JC> Thanks, but I still got complains that can't access server: JC> 'Access denied for user: 'root@localhost' (Using password: YES) JC> Is it possible that for some reason the password is wrong? Yup. If you don't remember 'root' password, reset it by the following instruction: http://www.mysql.com/doc/en/Resetting_permissions.html -- 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 for user: root@localhost
Just a question, did you ever change your password for Mysql? If not don't use the -p option mysqladmin -u root create testdb On Tue, 2002-11-05 at 11:08, Jack Chen wrote: > Thanks, but I still got complains that can't access server: > > 'Access denied for user: 'root@localhost' (Using password: YES) > > Is it possible that for some reason the password is wrong? > > You input is greatly appreaciated, > > Puzzled newbie, > > Jack > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > On 5 Nov 2002, Michael Gargiullo wrote: > > > right, sorry, I could have been more specific. > > > > like so: mysqladmin -u root -p command, command... > > > > example: mysqladmin -u root -p create mytestdatabase > > > > On Tue, 2002-11-05 at 10:33, Jack Chen wrote: > > > Stangely, it gave me a page of *information* like this: [any idea? > > > thanks!] > > > > > > mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386 > > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > > > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > > > and you are welcome to modify and redistribute it under the GPL license > > > > > > Administration program for the mysqld daemon. > > > Usage: mysqladmin [OPTIONS] command command > > > > > > -#, --debug=... Output debug log. Often this is 'd:t:o,filename` > > > -f, --force Don't ask for confirmation on drop database; with > > > multiple commands, continue even if an error > > > occurs > > > -?, --help Display this help and exit > > > --character-sets-dir=... > > > Set the character set directory > > > -C, --compressUse compression in server/client protocol > > > -h, --host=#Connect to host > > > -p, --password[=...]Password to use when connecting to server > > > If password is not given it's asked from the tty > > > -P --port=... Port number to use for connection > > > -i, --sleep=sec Execute commands again and again with a sleep > > > between > > > -r, --relativeShow difference between current and previous > > > values > > > when used with -i. Currently works only with > > > extended-status > > > -E, --verticalPrint output vertically. Is similar to --relative, > > > but prints output vertically. > > > -s, --silentSilently exit if one can't connect to server > > > -S, --socket=...Socket file to use for connection > > > -u, --user=#User for login if not current user > > > -v, --verbose Write more information > > > -V, --version Output version information and exit > > > -w, --wait[=retries] Wait and retry if connection is down > > > > > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > > > > On 5 Nov 2002, Michael Gargiullo wrote: > > > > > > > use: mysqladmin -u root -p > > > > > > > > It will prompt you for the password > > > > > > > > On Tue, 2002-11-05 at 10:03, Jack Chen wrote: > > > > > Dear all, > > > > > > > > > > When I ran the follwing command: > > > > > > > > > > >$ mysqladmin -u root password PASSWORD > > > > > mysqladmin: connect to server at 'localhost' failed > > > > > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > > > > > > > > > Could you inform me why? > > > > > > > > > > Thanks, > > > > > > > > > > Jack > > > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 117
Re: access denied for user: root@localhost
Thanks, but I still got complains that can't access server: 'Access denied for user: 'root@localhost' (Using password: YES) Is it possible that for some reason the password is wrong? You input is greatly appreaciated, Puzzled newbie, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On 5 Nov 2002, Michael Gargiullo wrote: > right, sorry, I could have been more specific. > > like so: mysqladmin -u root -p command, command... > > example: mysqladmin -u root -p create mytestdatabase > > On Tue, 2002-11-05 at 10:33, Jack Chen wrote: > > Stangely, it gave me a page of *information* like this: [any idea? > > thanks!] > > > > mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386 > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > > and you are welcome to modify and redistribute it under the GPL license > > > > Administration program for the mysqld daemon. > > Usage: mysqladmin [OPTIONS] command command > > > > -#, --debug=... Output debug log. Often this is 'd:t:o,filename` > > -f, --force Don't ask for confirmation on drop database; with > > multiple commands, continue even if an error > > occurs > > -?, --helpDisplay this help and exit > > --character-sets-dir=... > > Set the character set directory > > -C, --compressUse compression in server/client protocol > > -h, --host=# Connect to host > > -p, --password[=...] Password to use when connecting to server > > If password is not given it's asked from the tty > > -P --port=...Port number to use for connection > > -i, --sleep=sec Execute commands again and again with a sleep > > between > > -r, --relativeShow difference between current and previous > > values > > when used with -i. Currently works only with > > extended-status > > -E, --verticalPrint output vertically. Is similar to --relative, > > but prints output vertically. > > -s, --silent Silently exit if one can't connect to server > > -S, --socket=... Socket file to use for connection > > -u, --user=# User for login if not current user > > -v, --verbose Write more information > > -V, --version Output version information and exit > > -w, --wait[=retries] Wait and retry if connection is down > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > On 5 Nov 2002, Michael Gargiullo wrote: > > > > > use: mysqladmin -u root -p > > > > > > It will prompt you for the password > > > > > > On Tue, 2002-11-05 at 10:03, Jack Chen wrote: > > > > Dear all, > > > > > > > > When I ran the follwing command: > > > > > > > > >$ mysqladmin -u root password PASSWORD > > > > mysqladmin: connect to server at 'localhost' failed > > > > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > > > > > > > Could you inform me why? > > > > > > > > Thanks, > > > > > > > > Jack > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > - > > > > 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]> > &
Re: access denied for user: root@localhost
Jack Chen wrote: >> $ mysqladmin -u root password PASSWORD > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > Could you inform me why? That's why: $ mysqladmin -uroot -pyourpassword PASSWORD newpassword -- ./ premax ./ [EMAIL PROTECTED] - 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 for user: root@localhost
right, sorry, I could have been more specific. like so: mysqladmin -u root -p command, command... example: mysqladmin -u root -p create mytestdatabase On Tue, 2002-11-05 at 10:33, Jack Chen wrote: > Stangely, it gave me a page of *information* like this: [any idea? > thanks!] > > mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Administration program for the mysqld daemon. > Usage: mysqladmin [OPTIONS] command command > > -#, --debug=... Output debug log. Often this is 'd:t:o,filename` > -f, --force Don't ask for confirmation on drop database; with > multiple commands, continue even if an error > occurs > -?, --help Display this help and exit > --character-sets-dir=... > Set the character set directory > -C, --compressUse compression in server/client protocol > -h, --host=#Connect to host > -p, --password[=...]Password to use when connecting to server > If password is not given it's asked from the tty > -P --port=... Port number to use for connection > -i, --sleep=sec Execute commands again and again with a sleep > between > -r, --relativeShow difference between current and previous > values > when used with -i. Currently works only with > extended-status > -E, --verticalPrint output vertically. Is similar to --relative, > but prints output vertically. > -s, --silentSilently exit if one can't connect to server > -S, --socket=...Socket file to use for connection > -u, --user=#User for login if not current user > -v, --verbose Write more information > -V, --version Output version information and exit > -w, --wait[=retries] Wait and retry if connection is down > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > On 5 Nov 2002, Michael Gargiullo wrote: > > > use: mysqladmin -u root -p > > > > It will prompt you for the password > > > > On Tue, 2002-11-05 at 10:03, Jack Chen wrote: > > > Dear all, > > > > > > When I ran the follwing command: > > > > > > >$ mysqladmin -u root password PASSWORD > > > mysqladmin: connect to server at 'localhost' failed > > > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > > > > > Could you inform me why? > > > > > > Thanks, > > > > > > Jack > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > - > > > 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: access denied for user: root@localhost
Stangely, it gave me a page of *information* like this: [any idea? thanks!] mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Administration program for the mysqld daemon. Usage: mysqladmin [OPTIONS] command command -#, --debug=... Output debug log. Often this is 'd:t:o,filename` -f, --force Don't ask for confirmation on drop database; with multiple commands, continue even if an error occurs -?, --helpDisplay this help and exit --character-sets-dir=... Set the character set directory -C, --compressUse compression in server/client protocol -h, --host=# Connect to host -p, --password[=...] Password to use when connecting to server If password is not given it's asked from the tty -P --port=...Port number to use for connection -i, --sleep=sec Execute commands again and again with a sleep between -r, --relativeShow difference between current and previous values when used with -i. Currently works only with extended-status -E, --verticalPrint output vertically. Is similar to --relative, but prints output vertically. -s, --silent Silently exit if one can't connect to server -S, --socket=... Socket file to use for connection -u, --user=# User for login if not current user -v, --verbose Write more information -V, --version Output version information and exit -w, --wait[=retries] Wait and retry if connection is down Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On 5 Nov 2002, Michael Gargiullo wrote: > use: mysqladmin -u root -p > > It will prompt you for the password > > On Tue, 2002-11-05 at 10:03, Jack Chen wrote: > > Dear all, > > > > When I ran the follwing command: > > > > >$ mysqladmin -u root password PASSWORD > > mysqladmin: connect to server at 'localhost' failed > > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > > > Could you inform me why? > > > > Thanks, > > > > Jack > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > > > - > > 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: access denied for user: root@localhost
use: mysqladmin -u root -p It will prompt you for the password On Tue, 2002-11-05 at 10:03, Jack Chen wrote: > Dear all, > > When I ran the follwing command: > > >$ mysqladmin -u root password PASSWORD > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > Could you inform me why? > > Thanks, > > Jack > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > - > 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
access denied for user: root@localhost
Dear all, When I ran the follwing command: >$ mysqladmin -u root password PASSWORD mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' Could you inform me why? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - 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 for user with granted privileges
You must issue flush privileges; to the sql query line. ~K Black -Original Message- From: alex [mailto:alex@;dynaweb.ru] Sent: Thursday, October 31, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: access denied for user with granted privileges Hi ppl! I've got a strange problem. I've created a user account with access to some concrete database using GRANT query (see below) but I cannot connect to the server using this usename only when connecting via mysql_real_connect() from C API. When using "mysql -u MY_USER" it works fine. What's wrong? Initial action is: make_scrambled_password(passwd,MY_USER_PASSWD); sprintf(query,"grant insert,index,select,update on my_database.* to %s identified by password '%s'",MY_USER,passwd); mysql_query(db,query); all appropriate records are placed in privilege tables - I checked. But when trying: mysql_real_connect(db,"localhost",MY_USER,MY_USER_PASSWD,"my_database",0,"", 0); I get and error message "Access denied to user MY_USER@localhost (Use password=YES)" What's going bad? Alex - 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
access denied for user with granted privileges
Hi ppl! I've got a strange problem. I've created a user account with access to some concrete database using GRANT query (see below) but I cannot connect to the server using this usename only when connecting via mysql_real_connect() from C API. When using "mysql -u MY_USER" it works fine. What's wrong? Initial action is: make_scrambled_password(passwd,MY_USER_PASSWD); sprintf(query,"grant insert,index,select,update on my_database.* to %s identified by password '%s'",MY_USER,passwd); mysql_query(db,query); all appropriate records are placed in privilege tables - I checked. But when trying: mysql_real_connect(db,"localhost",MY_USER,MY_USER_PASSWD,"my_database",0,"",0); I get and error message "Access denied to user MY_USER@localhost (Use password=YES)" What's going bad? Alex - 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 for user
luoya, Wednesday, October 02, 2002, 8:32:21 AM, you wrote: ll> I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root ll> so I use the following commands: ll> mysql> use mysql ll> Database changed ll> mysql> update user set password=password('l05m') ll> -> where host='localhost' and user='root'; ll> Query OK, 1 row affected (0.00 sec) ll> Mysql prompt a password be set. So I use the following commands to reload ll> system parameters: ll> C:\mysql\bin>mysqladmin reload ll> But mysql shows: ll> mysqladmin: connect to server at 'localhost' failed ll> error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)' It means that anonymous user doesn't have RELOAD_priv. ll> then I use the new password to start mysql. ll> C:\mysql\bin>mysql -hlocalhost -uroot -p ll> Enter password: ll> mysql shows: ll> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ll> Does anybody give help for me? You enter new 'root' password, bun new privileges take effect only after restart mysql daemon, or after mysqladmin reload, or after mysqladmin flush-privileges, or after FLUSH PRIVILEGES command if you update grant tables manually. So, you should use mysqladmin -uroot -hlocalhost reload if 'root' didn't have a password before or if 'root' had a password mysqladmin -uroot -hlocalhost -p reload and enter old 'root' 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 for user
Hi, You forgot : "FLUSH PRIVILEGES;" Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "luoya li" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 7:32 AM Subject: Access denied for user > > > Hi, > I have Mysql 3.23.52-max-nt on Win2K. IĄŻd like to set a password for root > so I use the following commands: > > mysql> use mysql > Database changed > mysql> update user set password=password('l05m') > -> where host='localhost' and user='root'; > Query OK, 1 row affected (0.00 sec) > > Mysql prompt a password be set. So I use the following commands to reload > system parameters: > > C:\mysql\bin>mysqladmin reload > > But mysql shows: > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)' > > then I use the new password to start mysql. > > C:\mysql\bin>mysql -hlocalhost -uroot -p > Enter password: > > mysql shows: > ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) > > Does anybody give help for me? > > Thanks for any suggestions, > > > Alice > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > > > - > 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
Access denied for user
Hi, I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root so I use the following commands: mysql> use mysql Database changed mysql> update user set password=password('l05m') -> where host='localhost' and user='root'; Query OK, 1 row affected (0.00 sec) Mysql prompt a password be set. So I use the following commands to reload system parameters: C:\mysql\bin>mysqladmin reload But mysql shows: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)' then I use the new password to start mysql. C:\mysql\bin>mysql -hlocalhost -uroot -p Enter password: mysql shows: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Does anybody give help for me? Thanks for any suggestions, Alice _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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
Access denied for user
Hi I just installed a mysql 3.23.52. I want to set a password for root. But when I execute : C:\mysql\bin\mysqladmin -u root password aaa system remind: mysqladmin:connect to server at 'localhost' failed error: Access denied for user:'root@localhost'(using password:No) Please tell me why? thanks for any help. Alice _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: ERROR 1044: Access denied for user
It means you don't have enough privileges to access 'mysql' database. You can add these privileges using "GRANT" command under user 'root' (or under another superuser). Check manual, the section about privileges. anjani.sinha wrote: > Hi all, > > I am getting the error when trying to connect server from my client: > > ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database > 'mysql' > > any answer? > > thanks, > > anjani > > > - > 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 > > > -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 - 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
ERROR 1044: Access denied for user
Hi all, I am getting the error when trying to connect server from my client: ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database 'mysql' any answer? thanks, anjani - 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: error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Hi David, On Fri, Jun 21, 2002 at 03:59:33AM -0400, david wrote: > Well i seem to have gotten MySql working but i can't seem to use mysqladmin: > to do anything. When i start MySql with the following: > > [root@RR davidwri]# safe_mysqld -u root > Starting mysqld daemon with databases from /var/lib/mysql > > > it will sit indefinitely as above, is this correct? Yes. You probably want to add an & to the end so it runs in the background. This is all standard shell functionality. Or even run it in its own subshell: [root@RR davidwri]# (safe_mysqld -u root &) > If i try to add: > mysql -u root -p mysql > > It still just sits,... > That's right. You didn't get your prompt back as you wrote earlier. > [root@RR davidwri]# mysqladmin version > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > You tell the mysql client to not use a password and root needs a password. So the MySQL daemon won't allow you to log in like this. > I did Set the password, based on the following syntax example (with my value, > obviously): > SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password'); > > So if i cntrl-z: > > [1]+ Stopped safe_mysqld -u root > > then try: > [root@RR davidwri]# mysql -u root > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > Like before. > [root@RR davidwri]# mysql -u root -p mysql > 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 2 to server version: 3.23.32 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer > > mysql> > Correct. You told the mysql client to ask you for a password. > I have never set up and administered MySql myself, so i don't know exactly > what to expect but this is definitely not right. thanks for all your help > Nothing unexpected so far. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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: error: 'Access denied for user: 'root@localhost' (Using password: NO)'
On Fri, 21 Jun 2002 03:59:33 -0400 david <[EMAIL PROTECTED]> wrote: > [root@RR davidwri]# mysqladmin version > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > [root@RR davidwri]# mysql -u root -p mysql > 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 Everytime you do : mysql or mysqladmin you have to add these parameters : -u root -p e.g. : mysqladmin -u root -p version mysql -u root -p [databasename] -- Let's call it an accidental feature. -- Larry Wall - 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
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Well i seem to have gotten MySql working but i can't seem to use mysqladmin: to do anything. When i start MySql with the following: [root@RR davidwri]# safe_mysqld -u root Starting mysqld daemon with databases from /var/lib/mysql it will sit indefinitely as above, is this correct? If i try to add: mysql -u root -p mysql It still just sits,... [root@RR davidwri]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I did Set the password, based on the following syntax example (with my value, obviously): SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password'); So if i cntrl-z: [1]+ Stopped safe_mysqld -u root then try: [root@RR davidwri]# mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [root@RR davidwri]# mysql -u root -p mysql 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 2 to server version: 3.23.32 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> I have never set up and administered MySql myself, so i don't know exactly what to expect but this is definitely not right. thanks for all your help - 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
[JDBC / MySQL] Access Denied for User ?
I am not sure if a Java JDBC error is appropriate for this list or not. If not, I apologize in advance. I'm getting the error below that I'm trying figure out where to start researching... "Invalid authorization- access denied for user"... This seems strange b/c I'm using "root" as username, "secret" is password. I'm able to log into mysql using that info so I'm not sure why I don't have access to this particular table. I was under the impression that the "root" user in MySQL had permissions to all tables... hmmm [my code is below if anyone is interested- i know it's not very exciting- i'm very new to both Java & MySQL] [lfindle@localhost java]$ javac TestMMDriver.java [lfindle@localhost java]$ java TestMMDriver java.sql.SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at java.lang.Throwable.fillInStackTrace(Throwable.java:native) at java.lang.Throwable.(Throwable.java:38) at java.lang.Exception.(Exception.java:24) at java.sql.SQLException.(SQLException.java:22) at org.gjt.mm.mysql.MysqlIO.init(source file unknown:line unknown, pc 0x829148e) at org.gjt.mm.mysql.Connection.connectionInit(source file unknown:line unknown, pc 0x826044b) at org.gjt.mm.mysql.jdbc1.Connection.connectionInit(Connection.java:92) at org.gjt.mm.mysql.Driver.connect(source file unknown:line unknown, pc 0x824eab1) at java.sql.DriverManager.getConnection(DriverManager.java:61) at java.sql.DriverManager.getConnection(DriverManager.java:49) at TestMMDriver.main(TestMMDriver.java:35) Any suggestions on where to research these errors would be most appreciated... Thanks, in advance- Laura AIM- lefindley --- import java.io.*; import java.sql.*; //import java.sql.ResultSetMetaData; import jpb.*; import java.util.*; // JDBC Imports import org.gjt.mm.mysql.*; import org.gjt.mm.mysql.Connection; import org.gjt.mm.mysql.Statement; import org.gjt.mm.mysql.Driver; import org.gjt.mm.mysql.ResultSet; public class TestMMDriver { public static void main(String[] args){ Connection con = null; try { String url = "jdbc:mysql://localhost:80/brandonbooks"; Statement stmt; ResultSet rs; Class.forName("org.gjt.mm.mysql.Driver"); con = (Connection) DriverManager.getConnection(url,"root","secret"); } catch (java.sql.SQLException e) { e.printStackTrace(); } catch(java.lang.ClassNotFoundException e){ e.printStackTrace(); } finally { if (con != null){ try { con.close(); } catch (Exception e){ } } } } } - 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: [MyODBC]Access denied for user: 'ODBC@localhost'
in the DSN settings, each datasource has a different username and password. and looking over the DSNs, none of them should be using the username ODBC@localhost. On Thursday 06 June 2002 9:18, you wrote: > Ray, > Thursday, June 06, 2002, 4:39:11 PM, you wrote: > > R> Error Occurred While Processing Request > > R> Error Diagnostic Information > > R> ODBC Error Code = S1000 (General error) > > R> [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: > NO) > > R> The error occurred while processing an element with a general identifier > of R> (CFQUERY), occupying document position (3:1) to (4:39). > > R> Date/Time: 06/06/02 06:34:43 > R> Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) > Gecko/20020529 > > R> it was working fine yesterday... what is probably the problem? > R> also i can't use phpMyAdmin anymore from the same machine. i can use > the R> command line mysql just fine though. > > If you can connect with command line client but connection fails with > phpMyAdmin and MyODBC it's probably wrong connection parameters. Please, > check you DSN. - 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: [MyODBC]Access denied for user: 'ODBC@localhost'
Ray, Thursday, June 06, 2002, 4:39:11 PM, you wrote: R> Error Occurred While Processing Request R> Error Diagnostic Information R> ODBC Error Code = S1000 (General error) R> [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) R> The error occurred while processing an element with a general identifier of R> (CFQUERY), occupying document position (3:1) to (4:39). R> Date/Time: 06/06/02 06:34:43 R> Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 R> it was working fine yesterday... what is probably the problem? R> also i can't use phpMyAdmin anymore from the same machine. i can use the R> command line mysql just fine though. If you can connect with command line client but connection fails with phpMyAdmin and MyODBC it's probably wrong connection parameters. Please, check you DSN. -- 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: [MyODBC]Access denied for user: 'ODBC@localhost'
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a user "ODBC@localhost" fixed it. all off a sudden i need a user named ODBC@localhost, and last i checked, i'm the only one here that knows anything about how to use mysql here at the office. so what might have been changed that would cause this. MyODBC has the correct username/password for the databases it uses. MS Access can open the ODBC databases without any problems (before i created the ODBC@localhost) its only the web server that seems to need the user. (ColdFusion & PHP) and how do i change it back to not need the odbc@localhost user anymore (again)? and it turns out (just to mislead me even more...) Mozilla 1.0 running on linux isn't working correctly with phpmyadmin using cookie auth. (don't know if its just me, or just mozilla...) after login in, it shows me 2 frames, both with login screens. On Thursday 06 June 2002 8:39, you wrote: > Error Occurred While Processing Request > > Error Diagnostic Information > > ODBC Error Code = S1000 (General error) > > [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (3:1) to (4:39). > > Date/Time: 06/06/02 06:34:43 > Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 > > it was working fine yesterday... what is probably the problem? > also i can't use phpMyAdmin anymore from the same machine. i can use the > command line mysql just fine though. > > its running off of a win2k machine > > - > 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 -- To one large turkey add one gallon of vermouth and a demijohn of Angostura bitters. Shake. -- F. Scott Fitzgerald, recipe for turkey cocktail. - 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
[MyODBC]Access denied for user: 'ODBC@localhost'
Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:39). Date/Time: 06/06/02 06:34:43 Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 it was working fine yesterday... what is probably the problem? also i can't use phpMyAdmin anymore from the same machine. i can use the command line mysql just fine though. its running off of a win2k machine - 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: ERROR 1045: Access denied for user: 'root@localhost'
MySQL 'root' user has got nothing to do with Unix 'root' user. Quoted from http://www.mysql.com/doc/C/h/Changing_MySQL_user.html is "Note that accessing MySQL as root, by supplying -u root on the command line, has nothing to do with MySQL running as the Unix root user, or, indeed, as another Unix user. The access permissions and user names of MySQL are completely separate from Unix user names. The only connection with Unix user names is that if you don't provide a -u option when you invoke a client program, the client will try to connect using your Unix login name as your MySQL user name." You might also want to check out: http://www.mysql.com/doc/U/s/User_Account_Management.html Gurhan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom McDonough Sent: Thursday, April 25, 2002 10:40 AM To: [EMAIL PROTECTED] Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' I am having the same problem and cannot find any document which can get me beyond Access denied... Could you explain the difference between Linux 'root' user and 'root' user in MySQL? Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' From: Victoria Reznichenko Date: Tue, 23 Apr 2002 16:38:01 +0300 >> [root@omsrh etc]# mysql >> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) It means that anonymous user doesn't have any privileges ... Unix 'root' user and 'root' user in MySQL are different ... - 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: ERROR 1045: Access denied for user: 'root@localhost'
Hi, After installation it's necessary to run mysq_install_db.sh.This script have some routines to resolve the host,create system mySQL tables and write the default option in this tables.For this reason, if you have some network configuration problem, it's a good idea to use '-h' option and "said" to mysql daemon what host must be resolved. Eg: mysql -u root -h host_name_of_your_Linux_machine -p Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Tom McDonough <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 5:40 PM Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' > I am having the same problem and cannot find any document which can get > me beyond Access denied... > Could you explain the difference between Linux 'root' user and 'root' > user in MySQL? > > Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' > From: Victoria Reznichenko > Date: Tue, 23 Apr 2002 16:38:01 +0300 > > > >> [root@omsrh etc]# mysql > >> ERROR 1045: Access denied for user: 'root@localhost' (Using password: > NO) > >It means that anonymous user doesn't have any privileges ... >Unix 'root' user and 'root' user in MySQL are different ... > > > > > - > 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: ERROR 1045: Access denied for user: 'root@localhost'
Tom, Thursday, April 25, 2002, 5:40:11 PM, you wrote: TM> I am having the same problem and cannot find any document which can get TM> me beyond Access denied... TM> Could you explain the difference between Linux 'root' user and 'root' TM> user in MySQL? MySQL user 'root' is usual user, it's a user with name 'root'. :) By default 'root' user in MySQL has all privileges, but you can change it. When you connect to the MySQL server, run MySQL utilities you can use option '--user='. MySQL uses to indentified user (password and host also are used for identification). If you don't specify user name, it means that you connected as anonymous user. Anonymous users are defined by inserting entries with User='' into the mysql.user table or creating an user with an empty name with the GRANT command. 'root' user in Linux is a "superuser" of OS, not of MySQL. Look at the MySQL documentation, there are a LOT a of info about privilege system in MySQL: http://www.mysql.com/doc/P/r/Privilege_system.html http://www.mysql.com/doc/U/s/User_Account_Management.html TM> Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' TM> From: Victoria Reznichenko TM> Date: Tue, 23 Apr 2002 16:38:01 +0300 >>> [root@omsrh etc]# mysql >>> ERROR 1045: Access denied for user: 'root@localhost' (Using password: TM> NO) TM>It means that anonymous user doesn't have any privileges ... TM>Unix 'root' user and 'root' user in MySQL are different ... -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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: ERROR 1045: Access denied for user: 'root@localhost'
I am having the same problem and cannot find any document which can get me beyond Access denied... Could you explain the difference between Linux 'root' user and 'root' user in MySQL? Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' From: Victoria Reznichenko Date: Tue, 23 Apr 2002 16:38:01 +0300 >> [root@omsrh etc]# mysql >> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) It means that anonymous user doesn't have any privileges ... Unix 'root' user and 'root' user in MySQL are different ... - 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: ERROR 1045: Access denied for user: 'root@localhost'
Tewfic, Monday, April 22, 2002, 10:07:06 PM, you wrote: >> Hello, i'm having a problem accessing mysql database. I don't recall >> setting a password for root, but when i try to set that password. This is >> happening right after i run mysql_install_db >> >> [root@omsrh etc]# mysql -u root -p >> Enter password:** >> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) If you didn't set password, you don't have to use '-p' option for connection. If you want to set password, please, chaeck the following link: http://www.mysql.com/doc/P/a/Passwords.html >> [root@omsrh etc]# mysql >> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) It means that anonymous user doesn't have any privileges ... Unix 'root' user and 'root' user in MySQL are different ... >> I was able access Mysql not being root, but couldn't get access to 'mysql' >> database to change user options and all. >> >> When accessing mysql as a user, I am unable to create databases. >> >> >> When using skip-grant-table i get ... >> >> [root@omsrh etc]# mysql -u root >> mysql: unrecognized option `--skip-grant-table' Use "--skip-grant-tables" option, not "--skip-grant-table" ... >> Your help will be greatly appreciated. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
ERROR 1045: Access denied for user: 'root@localhost'
> Hello, i'm having a problem accessing mysql database. I don't recall > setting a password for root, but when i try to set that password. This is > happening right after i run mysql_install_db > > [root@omsrh etc]# mysql -u root -p > Enter password:****** > ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) > > > [root@omsrh etc]# mysql > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > > I was able access Mysql not being root, but couldn't get access to 'mysql' > database to change user options and all. > > When accessing mysql as a user, I am unable to create databases. > > > When using skip-grant-table i get ... > > [root@omsrh etc]# mysql -u root > mysql: unrecognized option `--skip-grant-table' > > Your help will be greatly appreciated. - 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: Newbie: access denied for user
You must specify the -p to the mysql, so it prompts you for a password. > I'm learning mySQL and I think I missed something or > missconfigured...because I get an Access denied error. Any hints what I am > missing? What should I check? > mysql -u root mysql > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > > # ./mysql -u root test > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852-9008 Ramal 31 [EMAIL PROTECTED] - 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
Newbie: access denied for user
I'm learning mySQL and I think I missed something or missconfigured...because I get an Access denied error. Any hints what I am missing? What should I check? OS: OpenBSD 3.0 # ./mysqladmin -u root -p ver Enter password: ./mysqladmin Ver 8.23 Distrib 3.23.49, for unknown-openbsd3.0 on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 36 min 48 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002 _ mysql -u root mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) # ./mysql -u root test ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) Mitja - 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 for user: (from perl script)
Hello list, I am attempting to run: >perl -MCPAN -e 'install DBD::mysql'< I am having a similar problem as the message that is in this subject line, reported by Jon Ingason in a message dated March 1, 2002. I must have tried the install routine at least 15 times, varying different settings that I thought would force the system to use a different test file, fix permissions, etc. I even installed a new mysql and Perl, but all efforts have produces no better results. I get an unable to connect error. It gets through most of the install routine just fine, until attempting to access the test database. I didn't know whether the test database should be created or not, but I've tried it both ways. Then I switched to having the system use the database which I know I can access at the command line to add records and privileges. At first, I thought it was due to a GRANT PRIVILEGES issue, so I spent quite a bit of time making sure that the database was accessible, passwords were set up correctly, etc. The DBD file is DBD-mysql-2.1011. Should I be using >Bundle::DBD:mysql< ? Would that make this setup routine any easier? If the database is accessible at the command line, why would it not be unable to connect when using the perl install routine? TIA for any help. Andrew Lietzow The ACL Group, Inc. [EMAIL PROTECTED] - 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
Access denied for user
I dont know what I have done now but I have locked myself out of mysql. When I type mysql I get an access violation. At first I thought it might have been something on my end since I am a remote user. But when I attempt to enter mysql from linux box. I get the same access violation... Please someone help me. - 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
Access denied for user: 'root@localhost'
root login failing??? why? anonymus failing too?? I just installed the following on Win2k Server: Ver 8.23 Distrib 3.23.47, for Win95/Win98 on i32 Server version 3.23.47-max-nt Install goes seemingly ok. I test whether or not MySQL is working and have problem with this command below... C:\mysql\bin>mysqlshow -u root mysql mysqlshow: Access denied for user: 'root@localhost' (Using password: NO) C:\mysql\bin>mysql mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' C:\mysql\bin\mysql test (this works ok) tia chris _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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 for user: (from perl script)
Are you using the latest version of DBI? Also, your "if ($dbh) {" seems a little backward. According to the DBI docs, "If the connect fails (see below) it returns undef and sets $DBI::err and $DBI::errstr." So shouldn't your conditional be "if (!$dbh) {". Perhaps you are actually connecting. I'm not sure why DBI::errstr would be defined in that case though. Also, I hope that is not your real connection info (i.e. username, password, hostname, database name). If it is, you should change it immediately. Duncan -- Duncan Salada | Titan | www.titan.com/validity Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 01, 2002 7:18 AM > To: [EMAIL PROTECTED] > Subject: Access denied for user: (from perl script) > > > Hi, I have a problem accessing MySQL database. I have a > database changes_db > and when I access it with mysql -h jon -u join -p changes_db, > I have no > problems. But if I use Perl script to access same database I get: > > DBI->connect(database=changes;host=jon;port=) failed: > Access denied for user: 'join@jon' to database 'changes_db' at > ./test_db.cgi line 15 > > The script is following: > > #!/usr/bin/perl -w > use strict; # enforce declarations and quoting > use DBI; > use CGI qw(:all);# import shortcuts > $| = 1; # disable buffering > > my $username = "join"; > my $password = "equant"; > my $database = "chances_db"; > my $driver = "mysql"; > my $port = ''; > my $hostname = "jon"; > > my $dsn = "DBI:$driver:database=$database;host=$hostname;port=$port"; > my $dbh = DBI->connect($dsn, $username, $password); > > if ($dbh) { > print $DBI::errstr; > exit 1; > } > > Regards > Jon Ingason > Sr Field Ops Eng > IP/Router Operation > Global One Services AB trading as Equant > Solna strandväg 82 > PO BOX 1 > 171 18 SOLNA > SWEDEN > > Work: +46 8 5191 3316 > Fax: +46 8 5191 3200 > Cellular: +46 708 91 3316 > E-mail: [EMAIL PROTECTED] > > > > - > 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
Access denied for user: (from perl script)
Hi, I have a problem accessing MySQL database. I have a database changes_db and when I access it with mysql -h jon -u join -p changes_db, I have no problems. But if I use Perl script to access same database I get: DBI->connect(database=changes;host=jon;port=) failed: Access denied for user: 'join@jon' to database 'changes_db' at ./test_db.cgi line 15 The script is following: #!/usr/bin/perl -w use strict; # enforce declarations and quoting use DBI; use CGI qw(:all);# import shortcuts $| = 1; # disable buffering my $username = "join"; my $password = "equant"; my $database = "chances_db"; my $driver = "mysql"; my $port = ''; my $hostname = "jon"; my $dsn = "DBI:$driver:database=$database;host=$hostname;port=$port"; my $dbh = DBI->connect($dsn, $username, $password); if ($dbh) { print $DBI::errstr; exit 1; } Regards Jon Ingason Sr Field Ops Eng IP/Router Operation Global One Services AB trading as Equant Solna strandväg 82 PO BOX 1 171 18 SOLNA SWEDEN Work: +46 8 5191 3316 Fax: +46 8 5191 3200 Cellular: +46 708 91 3316 E-mail: [EMAIL PROTECTED] - 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 for user varlehti
>LdS> I'm experiencing the same problem. >LdS> But I sort of found a way around it (though I'm sure this is not really the >right way). >LdS> When I "remove" the *password* for *root* and login again as root, I'm able to >create new users using GRANT then flush priviliges. >LdS> Does this mean I have to indicate the password of root while using GRANT? >LdS> I can't find any info on this on the docs, please point us to where we can find >the info for this. >LdS> thanks... > >Yes, using GRANT statment you can set password for user. >Look at: http://www.mysql.com/doc/G/R/GRANT.html > I still end up having a user with all privileges set to *N*, eventhough I created that user with mysql> grant all privileges > on dbase1.* > to user1 identified by 'user1password'; What am I doing wrong? luie __ www.edsamail.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
Access denied for user varlehti
Hello Markus, Tuesday, January 22, 2002, 12:27:44 PM, you wrote: ML> Hi all! ML> I've got quite a strange problem. Got to work today, was about to ML> continue my work on a database, and tried to log in with user ML> "varlehti", which is a user that's got SELECT, INSERT, UPDATE, ML> and DELETE -privileges. I got an Access denied -error, and ML> I'm sure I typed the password right. No, caps lock isn't on : ) ML> I logged in with root, typed in my root-password and that worked fine. ML> Used SELECT * FROM user; and lo and behold! The varlehti-users' privileges ML> were gone! ML> host was %, user was varlehti, and everything else was "N". ML> Tried to use GRANT SELECT,INSERT,UPDATE,DELETE ON database.* ML> TO varlehti@'%' IDENTIFIED BY 'password' ML> and FLUSH PRIVILEGES. ML> Nothing happened. Records in the table 'user' indicates user's global privileges. To examine user privileges on database.* look into mysql.db. Take a look at http://www.mysql.com/doc/P/r/Privileges.html ML> Tried to manually insert Y into the privilege columns. ML> Got them there, still Access denied. ML> So, I deleted the varlehti-user and tried to GRANT the privileges again. ML> FLUSH PRIVILEGES. ML> The user appeared in the user-table, but all privileges were N. ML> Tried again with INSERT INTO. Got everything added, flushed privileges ML> and tables and just about everything else. ML> Access denied. When you specify '%', you make it also to accept connections through TCP/IP. If you connect from the same box you will see "access denied". Have a short look at: http://www.mysql.com/doc/A/c/Access_denied.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Access denied for user varlehti
Hi all! I've got quite a strange problem. Got to work today, was about to continue my work on a database, and tried to log in with user "varlehti", which is a user that's got SELECT, INSERT, UPDATE, and DELETE -privileges. I got an Access denied -error, and I'm sure I typed the password right. No, caps lock isn't on : ) I logged in with root, typed in my root-password and that worked fine. Used SELECT * FROM user; and lo and behold! The varlehti-users' privileges were gone! host was %, user was varlehti, and everything else was "N". Tried to use GRANT SELECT,INSERT,UPDATE,DELETE ON database.* TO varlehti@'%' IDENTIFIED BY 'password' and FLUSH PRIVILEGES. Nothing happened. Tried to manually insert Y into the privilege columns. Got them there, still Access denied. So, I deleted the varlehti-user and tried to GRANT the privileges again. FLUSH PRIVILEGES. The user appeared in the user-table, but all privileges were N. Tried again with INSERT INTO. Got everything added, flushed privileges and tables and just about everything else. Access denied. Anyone got any idea what's causing this annoying little problem? And what's even more important, how come the privileges just disappeared? No one has got access to the database but me, and no one has got access to my computer, either. Ideas, anyone? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - 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 for user
Hi check if mysqld is running if not start it and try again. daniel josep wrote: >I get the following message when trying to view a php page > >Warning: Access denied for user: 'jupshoes@localhost' (Using password: YES) >in /home/jupshoes/public_html/guest/index.php on line 27 >Unable to connect to SQL server > >What is going wrong > >Josep > > >- >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: [PHP] Access denied for user
I would hazard a guess that you have supplied a username/password/host combination that isn't valid. Check in the mysql.user table, and check that there is an entry there for the user and host. Thepassword should be encrypted so you won't know if its what you're typing, but you should be able to alter this to something else if you think it might be wrong. One other thing worth noting, is that MySQL only picks up changes to user's and user permissions when either the server process is restarted, or you instruct it to "flush privileges". If this user has just been added then maybe something like this is your problem HTH Richy -Original Message- From: josep [SMTP:[EMAIL PROTECTED]] Sent: 06 December 2001 11:22 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP] Access denied for user I get the following message when trying to view a php page Warning: Access denied for user: 'jupshoes@localhost' (Using password: YES) in /home/jupshoes/public_html/guest/index.php on line 27 Unable to connect to SQL server What is going wrong Josep -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - 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: [PHP] Access denied for user
> I get the following message when trying to view a php page > > Warning: Access denied for user: 'jupshoes@localhost' (Using password: YES) > in /home/jupshoes/public_html/guest/index.php on line 27 > Unable to connect to SQL server The username or password is incorrect. Or the username does not have permission to log on from localhost -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - 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
access denied for user:
(Debian Linux 2.2) trying (logged in as the owner of the database): mysql guestbook.sql (database is palced in my home directory) I get: access denied for user: '@localhost' to database 'guestbook.sql' What is going wrong? - 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
Access denied for user: 'myuser@localhost'
I'm a complete newbie in mysql, so I've got a very simple question (I hope so): I've installed MySQL 3.23.44 on my Windows 2000Pro / IIS-5 /w PHP4 support. I followed the installation instructions on Win2000, made the databse to run, I managed to set the root password as it was said in the manual, but I have a problem. When I try to this URL (it's access my sites home url): http://195.244.133.***/start.php3 it doesn't show anything but: Warning: MySQL Connection Failed: Access denied for user: 'myuser@localhost' (Using password: YES) in C:\Inetpub\wwwroot\php\dplib.php3 on line 523 I haven't changed anything in the mysql configuration exept the root password, the right directories and pathes and my my.ini looks like: [mysqld] basedir=c:/mysql datadir=c:/mysql/data skip-innodb [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe Plz help me! - 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
Invalid authorization specification: Access denied for user: 'prodoc@ns' (Using password: YES)
Dear Madam, Sir, I created a new user with : ./mysql -u root -p1234 mysql grant select,insert,update,delete,create,drop on prodoc to prodoc@"%" identified by '1234'; In my asp script that is opening the connection I use : cnnString = "DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://xxx.xxx.xxx.xx:3306/dbname };uid=username;pwd=1234;" The error : Invalid authorization specification: Access denied for user: 'username@ns' (Using password: YES) Strange thing is that when I replace username with root, all works well... I even creates an admin with full rights, both for localhost and @"%", but still no good. All hints are wellcome. Kind regards, Harry M. Aasterud - 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: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message
If it is a TYPE IV driver means, ODBC won't come into picture. But the error string whatever you got shows that, you are trying to connect it through JDBC:ODBC bridge driver. Please refer to your driver manual for more information for making the connection with MySQL. If you are using mmmysql driver, please refer to the following link for more information. http://mmmysql.sourceforge.net/doc/mm.doc/book1.htm Thank you Venu Anuganti - Original Message - From: "shane" <[EMAIL PROTECTED]> To: "Venu Anuganti" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 12:11 AM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message > Hi, the driver which i am using is type IV. do i still need to install > myodbc? > > thks > > -Original Message- > From: Venu Anuganti [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 2:04 PM > To: shane > Cc: [EMAIL PROTECTED] > Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for > user... (Using password: No) message > > > Hi Shane > > To connect to MySQL using JDBC Driver, it depends up on the type of JDBC > driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) > then you need MyODBC installed on the system and configured properly as > explained in the earlier mail in the mysql list. > > Here is the link, which tells different types of JDBC drivers in the world. > http://java.sun.com/products/jdbc/driverdesc.html < or > > http://www.jguru.com/faq/view.jsp?EID=691 > > Let us know, what type of JDBC driver are you using to connect to MySQL ? > > Thank you > Venu Anuganti > > - Original Message - > From: "shane" <[EMAIL PROTECTED]> > To: "Venu Anuganti" <[EMAIL PROTECTED]> > Sent: Wednesday, July 18, 2001 10:39 PM > Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... > (Using password: No) message > > > > i am using the mmmysql jdbc driver, and i was wondering whether i need to > > install myodbc. > > i'm running mysql server on a linux machine and the binary version of the > > download from > > www.mysql.com does not include the odbc driver and the libraries required > > for myodbc. > > I'm running on a i686 but the rpm version they have is for i386 system > > > > thks > > shane > > > > -Original Message- > > From: Venu Anuganti [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, July 19, 2001 12:55 PM > > To: Luc Lalancette; [EMAIL PROTECTED] > > Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for > > user... (Using password: No) message > > > > > > Hi Luc > > > > Here is the common syntax, that is used as the connection string through > > JDBC-ODBC Driver. > > > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > > String url = "jdbc:odbc:TestDSN"; > > Coonection con = DriverManager.getConnection(url,"username","password"); > > > > Before connecting, make sure you intslled the ODBC Driver and configured > the > > DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error > > below, it looks you have the valid DSN, but you didn't supply the UID and > > PWD in the connection string. > > > > Thank you > > Venu Anuganti > > > > - Original Message - > > From: "Luc Lalancette" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, July 18, 2001 3:02 PM > > Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... > > (Using password: No) message > > > > > > I am starting using mysql and I made a java SimpleQuery servlet that is > > suppose to retreive one row from the database. However, when I try to > > connect I get that message from the Subject. I know I'm suppose to pass > the > > password but can't seem to find a way of doing it. I was wondering if the > > problem was with those two lines or if it was in the tdx mysql driver > > default configuration in the ODBC. > > > > Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > > dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;"); > > > > I would appreciate if someone could help me to get my connection going. > > Thank you very much > > Luc Lalancette > > > > > > > > - > > Before posting, please check: >
RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message
Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:04 PM To: shane Cc: [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi Shane To connect to MySQL using JDBC Driver, it depends up on the type of JDBC driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) then you need MyODBC installed on the system and configured properly as explained in the earlier mail in the mysql list. Here is the link, which tells different types of JDBC drivers in the world. http://java.sun.com/products/jdbc/driverdesc.html < or > http://www.jguru.com/faq/view.jsp?EID=691 Let us know, what type of JDBC driver are you using to connect to MySQL ? Thank you Venu Anuganti - Original Message - From: "shane" <[EMAIL PROTECTED]> To: "Venu Anuganti" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 10:39 PM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message > i am using the mmmysql jdbc driver, and i was wondering whether i need to > install myodbc. > i'm running mysql server on a linux machine and the binary version of the > download from > www.mysql.com does not include the odbc driver and the libraries required > for myodbc. > I'm running on a i686 but the rpm version they have is for i386 system > > thks > shane > > -Original Message- > From: Venu Anuganti [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 12:55 PM > To: Luc Lalancette; [EMAIL PROTECTED] > Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for > user... (Using password: No) message > > > Hi Luc > > Here is the common syntax, that is used as the connection string through > JDBC-ODBC Driver. > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > String url = "jdbc:odbc:TestDSN"; > Coonection con = DriverManager.getConnection(url,"username","password"); > > Before connecting, make sure you intslled the ODBC Driver and configured the > DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error > below, it looks you have the valid DSN, but you didn't supply the UID and > PWD in the connection string. > > Thank you > Venu Anuganti > > - Original Message - > From: "Luc Lalancette" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, July 18, 2001 3:02 PM > Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... > (Using password: No) message > > > I am starting using mysql and I made a java SimpleQuery servlet that is > suppose to retreive one row from the database. However, when I try to > connect I get that message from the Subject. I know I'm suppose to pass the > password but can't seem to find a way of doing it. I was wondering if the > problem was with those two lines or if it was in the tdx mysql driver > default configuration in the ODBC. > > Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;"); > > I would appreciate if someone could help me to get my connection going. > Thank you very much > Luc Lalancette > > > > - > 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
Fw: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message
-- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu Anuganti <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA <___/ www.mysql.com - Original Message - From: "Luc Lalancette" <[EMAIL PROTECTED]> To: "Venu Anuganti" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 10:04 PM Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message > Thanks again... It seems that I owe you one it worked. > Luc > - Original Message - > From: "Venu Anuganti" <[EMAIL PROTECTED]> > To: "Luc Lalancette" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, July 18, 2001 10:54 PM > Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... > (Using password: No) message > > > > Hi Luc > > > > Here is the common syntax, that is used as the connection string through > > JDBC-ODBC Driver. > > > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > > String url = "jdbc:odbc:TestDSN"; > > Coonection con = DriverManager.getConnection(url,"username","password"); > > > > Before connecting, make sure you intslled the ODBC Driver and configured > the > > DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error > > below, it looks you have the valid DSN, but you didn't supply the UID and > > PWD in the connection string. > > > > Thank you > > Venu Anuganti > > > > - Original Message - > > From: "Luc Lalancette" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, July 18, 2001 3:02 PM > > Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... > > (Using password: No) message > > > > > > I am starting using mysql and I made a java SimpleQuery servlet that is > > suppose to retreive one row from the database. However, when I try to > > connect I get that message from the Subject. I know I'm suppose to pass > the > > password but can't seem to find a way of doing it. I was wondering if the > > problem was with those two lines or if it was in the tdx mysql driver > > default configuration in the ODBC. > > > > Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > > dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;"); > > > > I would appreciate if someone could help me to get my connection going. > > Thank you very much > > Luc Lalancette > > > > - 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: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message
Hi Shane To connect to MySQL using JDBC Driver, it depends up on the type of JDBC driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) then you need MyODBC installed on the system and configured properly as explained in the earlier mail in the mysql list. Here is the link, which tells different types of JDBC drivers in the world. http://java.sun.com/products/jdbc/driverdesc.html < or > http://www.jguru.com/faq/view.jsp?EID=691 Let us know, what type of JDBC driver are you using to connect to MySQL ? Thank you Venu Anuganti - Original Message - From: "shane" <[EMAIL PROTECTED]> To: "Venu Anuganti" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 10:39 PM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message > i am using the mmmysql jdbc driver, and i was wondering whether i need to > install myodbc. > i'm running mysql server on a linux machine and the binary version of the > download from > www.mysql.com does not include the odbc driver and the libraries required > for myodbc. > I'm running on a i686 but the rpm version they have is for i386 system > > thks > shane > > -Original Message- > From: Venu Anuganti [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 12:55 PM > To: Luc Lalancette; [EMAIL PROTECTED] > Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for > user... (Using password: No) message > > > Hi Luc > > Here is the common syntax, that is used as the connection string through > JDBC-ODBC Driver. > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > String url = "jdbc:odbc:TestDSN"; > Coonection con = DriverManager.getConnection(url,"username","password"); > > Before connecting, make sure you intslled the ODBC Driver and configured the > DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error > below, it looks you have the valid DSN, but you didn't supply the UID and > PWD in the connection string. > > Thank you > Venu Anuganti > > - Original Message - > From: "Luc Lalancette" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, July 18, 2001 3:02 PM > Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... > (Using password: No) message > > > I am starting using mysql and I made a java SimpleQuery servlet that is > suppose to retreive one row from the database. However, when I try to > connect I get that message from the Subject. I know I'm suppose to pass the > password but can't seem to find a way of doing it. I was wondering if the > problem was with those two lines or if it was in the tdx mysql driver > default configuration in the ODBC. > > Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;"); > > I would appreciate if someone could help me to get my connection going. > Thank you very much > Luc Lalancette > > > > - > 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: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message
Hi Luc Here is the common syntax, that is used as the connection string through JDBC-ODBC Driver. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:TestDSN"; Coonection con = DriverManager.getConnection(url,"username","password"); Before connecting, make sure you intslled the ODBC Driver and configured the DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error below, it looks you have the valid DSN, but you didn't supply the UID and PWD in the connection string. Thank you Venu Anuganti - Original Message - From: "Luc Lalancette" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 3:02 PM Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the problem was with those two lines or if it was in the tdx mysql driver default configuration in the ODBC. Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;"); I would appreciate if someone could help me to get my connection going. Thank you very much Luc Lalancette - 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: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message
the method signature for getConnection is: public static synchronized Connection getConnection(String url, String user, String password) throws SQLException try PURE JSP Java Server Pages by James Goodwill from Sams. a nice book. has some coding errors. At 04:02 PM 7/18/01 -0600, you wrote: >I am starting using mysql and I made a java SimpleQuery servlet that is >suppose to retreive one row from the database. However, when I try to >connect I get that message from the Subject. I know I'm suppose to pass >the password but can't seem to find a way of doing it. I was wondering if >the problem was with those two lines or if it was in the tdx mysql driver >default configuration in the ODBC. > >Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); >dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;"); > >I would appreciate if someone could help me to get my connection going. >Thank you very much >Luc Lalancette -- tom marlin [EMAIL PROTECTED] fax / voice mail: 714 507 3802 ext 4881 Never be afraid to try something new. Remember that - amateurs built the ark. - professionals built the Titanic.
java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message
I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the problem was with those two lines or if it was in the tdx mysql driver default configuration in the ODBC. Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;"); I would appreciate if someone could help me to get my connection going. Thank you very much Luc Lalancette
Re: access denied for user root
It's a little hard to figure out why without seeing the commands you used but at a guess, I would say, when you first tried to get in, you used the -p option but of course no password had been set at that stage. - Original Message - From: "Simone Lucarelli" <[EMAIL PROTECTED]> To: "mysql list" <[EMAIL PROTECTED]> Sent: Wednesday, May 16, 2001 0:48 Subject: access denied for user root > After installing mysql, when i try to connect the server > reply > access denied for root@localhost > > How is it possible? I set the password for user root, and > all seems to be right > > ++ SIMONE LUCARELLI > | _ | agenzia giornalistica > ||___ ___| | TUTTOCALCIO > | / / | editrice TuttoPress > | / / /--\| tel. 0572.75204 r.a. > | /_ / \__/|fax 0572.766622 > ++ [EMAIL PROTECTED] > > - > 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
access denied for user root
After installing mysql, when i try to connect the server reply access denied for root@localhost How is it possible? I set the password for user root, and all seems to be right ++ SIMONE LUCARELLI | _ | agenzia giornalistica ||___ ___| | TUTTOCALCIO | / / | editrice TuttoPress | / / /--\| tel. 0572.75204 r.a. | /_ / \__/|fax 0572.766622 ++ [EMAIL PROTECTED] - 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
SQLException: General error: Access denied for user:
Hi all, Here's my environment: Solaris 8 Mysql 3.23.33 Driver mm.mysql-2.0.2-bin.jar I installed Mysql use root. In my servlet program I did not use input parameter for user/password. I run my servlet program, I got the following message java.sql.SQLException: General error: Access denied for user: '@chicago' to database 'speed_data' at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java) at java.sql.DriverManager.getConnection(DriverManager.java:517) Can someone help me with this? Is there a achieve list? Where is it? I cannot find it in the documentation. _ Get your FREE download of MSN Explorer at http://explorer.msn.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