Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Software Craftsman
this week in the
JDBC and Relational Databases
connection to Mysql with username and password
Joined: Feb 16, 2005
Jul 28, 2005 00:36:00
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
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
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
I agree. Here's the link:
subject: connection to Mysql with username and password
jdbc connection AGGRAVATION!! Can you help?
NOt able to connect to actual database on the web server
mysql JDBC driver classpath problem.
JDBC_MySQL - Driver not possible to load
strange problem when accessing MySQL
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015