This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connection to Mysql with username and password

 
sitaram irrinki
Ranch Hand
Posts: 158
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have installed MySql4.1.13-0 on pcq linux and it is working fine.i have created a newdatabase and new user using the following commands;

i am logging into mysql using username root and passowrd also root

mysql>create database inetdb;

mysql>grant all privilges on inetdb.* to 'student'@'localhost' identified by 'student';

i have tried to connect to inetdb database using student user using the following command

mysql --username=student --password=student inetdb

then i am able to connect to inetdb and i am able to execute any kind of staments

but if try the samething from JDBC program like

Connection con=DriverManager.getConnection("jdbc:mysql://localhost/inetdb?username=student&password=student");

it is giving an error authorization exception using password:YES

where as if i try connect to default database "test" with out username and password
like

Connection con=DriverManager.getConnection("jdbc:mysql://localhost/test?username=&password=");

then i am able to connect

i don't what is reason behind this.i tried the samething in windows.it is working fine.

is there any need to create the users in mysql same as operating system users
in linux
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic