Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

connection to Mysql with username and password  RSS feed

sitaram irrinki
Ranch Hand
Posts: 158
  • 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

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 is working fine.

is there any need to create the users in mysql same as operating system users
in linux
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!