Re: Access denied on use mysql;
--- Kathy Reyes [EMAIL PROTECTED] wrote: Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... ^ What do you mean? Can you see the mysql prompt. If you acn then what's the problem. type 'use mysql' then type 'show tables' then do select * from .. so on - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; Kathy I see. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:48 PM Subject: Re: Access denied on use mysql; I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - 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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.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: Fw: Access denied on use mysql;
Hi, Check whether ur mysql is running using the following command. $/etc/rc.d/init.d/mysqld status if the reply is running... then type 'mysql' (if you have anonymous login) otherwise type 'mysql -u root -p' If you don't get the mysql prompt then you will have to add an user using mysqladmin, I haven't done that yet, read the manual. And let me know if you succeed. Regards, Liyju --- Kathy Reyes [EMAIL PROTECTED] wrote: I thought I was sending my email to the [EMAIL PROTECTED] but I guess I wasnt. Thank you so much for your help Alan, I cant figure out how I have lost access to 'mysql' (default) database. When I attempt to use mysql on my Linux machine I get the error message ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) How ever I can login using kreyes and ODBC. Can anyone please tell me where I can find that my.cnf file I've looked every where on my linux machine and cant find it. Thanks all!!! - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 11:59 AM Subject: Re: Access denied on use mysql; Kathy, First please cc to [EMAIL PROTECTED] . There are others who want to read it. But you said earlier about emails that did not do much of help. I was lucky. Perhaps you have to wait for your turn. First, I feel I am not ready to solve this problem for you because your telneting into the linux machine from Windows 2000 machine. I have never tried this. I can tell you what I know as a complete beginner. I need to correct my saying NET CLOSE SERVER. When it should be NET STOP SERVER. You need to use WINMYSQLADMIN for adding users. There may be other ways, but I only know this way. But in your case about telneting, I am not sure what your doing because I never tried it. I am not clear about telneting, are your accessing data remotely for editing,etc, from your local Mysql server. Or vice versa. your transmitting data from your local machine to the remote Mysql server. I think your just accessing remote data. Your reply may help. I can only describe about my present settings on my pc with mysql. The present settings right after the installation of Windows XP, I did not go anything beyond granting privileges to other users like you do. But it is ready to accept my typing input: USE MYSQL before the database changed in computer's reply. At that point, I assume I am granted access to this MYSQL database. Did you type in USE MYSQL command? I dont know why you cannot. I believe you should cc your emails to [EMAIL PROTECTED] Others will help you. I think you have mentioned emails, but got no help. Sometimes, patience pays off. Good luck. And then enlightment follows. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:54 AM Subject: Re: Access denied on use mysql; I signed in as follows mysql -h localhost -u kreyes. mysql is installed on a linux machine and I am connecting remotely from a Windows 2000 machine. When I had access as root I was able to add users and grants. I didnt give myself access to the 'msql' database because I didnt really need it. But up until yesterday I was able to go into mysql by telneting into the linux machine and then typing mysql but now I keep getting an error. I'm not sure what you mean by NET CLOSE MYSQL. I am kinda new to mysql. Please enlighten me - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:55 AM Subject: Re: Access denied on use mysql; Kathy, Sounds like mine, but it is fixed. I still dont know what the fix was. May I ask you how you signed in as Kreyes? Did you add username and password yourself? Since you are denied access to mysql (default) database, it surely sounded like mine. Before I may give you some help, may I ask you again how you signed in as Kreyes. Did you use mysqladmin? How long have you been using MySQL? Did you install recently? It sounds you may need to NET CLOSE MYSQL at DOS PROMPT. And then NET START MYSQL again. I am afraid there are still related programs running in the background. But five it a try. Two times at most. I did that several times over a few days period, before it worked correctly. And let me know. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:11 AM Subject: Re: Access denied on use mysql; I've tried everything thats in this email and nothing seems to work for me. I think my
Re: Java to MySQL connection
which Driver your using? which Operating system your using? If your using linux, as far as I know there is now odbc support. You have to downlaod mm.mysql driver. If your are using windows you will have to create a dsn name for the your selected driver. --- Chris Stewart [EMAIL PROTECTED] wrote: I'm trying to make a connection from a java app to a MySQL database I've created on my local PC. How can I tell the app where to look for the existing database? Code I'm working with: Class.forName(sun.jdbc.odbc.JdbcOdbcDriver).newInstance(); Connection con = DriverManager.getConnection(jdbc:odbc:Testing@localhost:3306, my username , my pass ); System.out.println(Connection Made.); As you can tell from this, my database is named Testing. All I'm trying to do right now is get a connection. Right now when I run this code I get Error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. I'm not sure I have the odbc driver setup correctly either. I downloaded mm.mysql-2.0.11 but I'm not really sure how to bring it into the mix as far as the driver goes. Thanks for any direction. Chris Stewart [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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.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: How to connect to mysql databases
what is the output of show database command --- amol sonaikar [EMAIL PROTECTED] wrote: Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's not working Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.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: How to connect to mysql databases
Do the folowing mysqlshow grant for root@localhost; mysqlgrant all on test.* to root@localhost identified by 'password'; $mysqladmin reload --- amol sonaikar [EMAIL PROTECTED] wrote: There is still error I did as per your say at mysql use test; but the error it gave was ERROR 1044: Access denied for user: '@localhost' to database 'test' even if I do something like this mysql mysql -u amol test -p ERROR 1045: Access denied for user: 'amol@localhost' (Using password: YES)This result we get . What can be way out. Is there any suggestions. Amol On Thu, 21 Mar 2002 16:35:56 -0800 Sherwin T. Ang [EMAIL PROTECTED] wrote: to connect to a certain database type in, mysql use databasename; where databasename is the name of your database. or you can specify the database in the command line like: mysql -uroot databasename -p where root is the user and databasename is the database to use/connect to. Hope that helps =) Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - Original Message - From: amol sonaikar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:17 AM Subject: How to connect to mysql databases Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's not working Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.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 - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.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 on use mysql;
--- alan4100 [EMAIL PROTECTED] wrote: The problem begins when I type in use mysql; Please look at the very left edge with three asterisks..*** where I marked. ACCESS denied Hope it will be fixed with your help so I can mind my own chores. == C:\mysql\binnet start mysql The MySql service is starting. The MySql service was started successfully. C:\mysql\binmysqladmin ping mysqld is alive C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql mysqld - \q Bye C:\mysql\binmysqld C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.02 sec) ***mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql use mysql -root ERROR 1044: Access denied for user: '@localhost' to database 'mysql' do the following: mysqlgrant all on test.* to user@localhost identified by 'password'; $mysqladmin reload mysql mysql - /q - \q Bye C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.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