A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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
It is sorta covered in the
JavaRanch Style Guide
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