A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Murach's Java Servlets and JSP
this week in the
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
rocket mass heater
subject: connection to Mysql with username and password
jdbc connection AGGRAVATION!! Can you help?
mysql JDBC driver classpath problem.
NOt able to connect to actual database on the web server
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-2014