Access denied ...
In my Linux machine the MySQL 3.x is running (installed via RPM, using /var/lib/mysql/mysql.soc). I am trying to login using following command but get the error as followed. [tom@host01 ~]$ mysql -u root test ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Then I tried using -S /var/lib/mysql/mysql.soc and it worked. My main objective is to access the database via Java. When I try to get the connection I get the error as 'Access denied ' I suspect that the socket information need to be provided somewhere in the jdbc:mysql://localhost:3306/mydb. How to resolve this problem? - 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
Paul DuBois Book
When the Next Edition of MySQL By Paul Dubois is coming? - 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
MySQL database in a File system
I need to create a database in MySQL that I need to bundle with my program for distribution. The user will have its own copy of MySQL running. User using my program will not bother about database issues and the bundled database will provide him, through my application program GUI, to enter/retrieve data. For this I have thought of using the file based database ie some file(s) will be bundled that are MySQL database. The configuration to tell where the MySQL is running that will operate on the file system database bundle will be done before running the program. How to create such database in MySQL. An analogy could be the way MS-ACCESS creates the .mdb file that one can use anywhere configuring the ODBC32 on windows. Regards - 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 Related Sites for MySQL
Same Here! Bryan! Do let me know if you find one. - Original Message - From: Aravind N V Gorthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 11, 2002 12:59 PM Subject: Java Related Sites for MySQL Hi Are there any JAVA based Forum sites which are using MySQL as the backend. I am new to MySQL and I am using JAVA. I want to know whether there are any sites which provide discussion forum,articles and tutorials on Java + MySQL..Just like weberdev.com,which provides discussion forums on PHP+MySQL. Thanks in advance Bryan. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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
JDBC - MySQL
I installed MySQL in my local dir (~) (RH Linux7.2). Created database successfully. No problems in operating on this database at mysql prompt. When I run my JDBC (Java) program it gives SQLException Server configuration denies access to data source. I am running the MySQL server using following command ./bin/mysqld_safe . I created the database named MYDB and given the log/pass as root/ (password nothing, as I do not have any password for root setup). There is no problem in loading the JDBC MySQL Driver. What is that need to be done to allow permission to use this database via JDBC? - 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
How to run commands written in a file
I have sql commands written in a file. How to run this file at sql prompt so that commands executed thru this batch file. Something similar to Oracles sql @/mydir/mysql.sql - 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
MySQL Book
Which is the **best, easy, compact** book available on MySQL. Delhi India. - 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: MySQL Book
Ok. So majority is towards Paul DuBois. I went to the http://www.newriders.com/ to see about this book and found that this book was published in Dec 1999. Is new edition out. Is it good enough for new version of MySQL 3.23.39 / MySQL 4.0.x. I do not want to buy a book that is outdated or going to be outdated. Please comment. - Original Message - From: Doug Poland [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: D Bamud [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:26 AM Subject: Re: MySQL Book D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1 -- Regards, Doug - 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
Server configuration denies access to data source
I installed MySQL in my local dir (~) (RH Linux7.2). Created database successfully. Can operate on this database at mysql prompt. I am trying to access the same database from my Java application THAT WAS working fine with the RMP installation of MySQL. When I run the program it gives SQLException Server configuration denies access to data source. I am running the MySQL server using following command ./bin/mysqld_safe . I created the database named TEST and given the log/pass as root/ (password nothing, as I do not have any password for root setup). What is that need to be done to allow permission to use this database via JDBC. - 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