using MySql

[Niranjan Deshpande]

Hi all,

I have developed an EJB application that accesses the database MySql that is shipped with the Glass fish server Sun Java System Application Server 9.1_01. The MySql database is running on port 3036. The database connection properties are mentioned in persistence.xml as:

 
<?xml version="1.0" encoding="UTF-8"?>
<persistence>
	<persistence-unit name="EntityService" transaction-type="RESOURCE_LOCAL">
        <class>com.entity.client.Employee</class>   
        <properties>   
            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>   
            <property name="hibernate.connection.username" value="admin"/>   
            <property name="hibernate.connection.password" value="adminadmin"/>   
            <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/_EntityService;create=true"/>   
            <property name="hibernate.hbm2ddl.auto" value="create"/>   
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>   
        </properties>   
	</persistence-unit>
</persistence>

But I get this exception when I run the client:

 
xception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:641)
	at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:40)
	at com.entity.client.EmployeeTest.main(EmployeeTest.java:28)
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
	at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:37)
	... 1 more
Caused by: java.sql.SQLException: Access denied for user 'admin'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
	... 6 more

Can any one please help me in creating some user using the mysql> command line utility.

[Vijitha Kumara]

Niranjan Deshpande wrote:Can any one please help me in creating some user using the mysql> command line utility.

Go to your mysql installation and change to bin folder from command prompt. Then issue this command,
mysql -uroot

(Normally root account comes with no password). Once you logged in you can create user accounts. Check this.

[Niranjan Deshpande]

Hi

I followed the steps that you mentioned.

When I do execute the command create user admin adminadmin at the mysql> prompt this is what I get, just a

->_

The cursor moves on the second line.

How do I know the command is executed? Any key to execute the command?

[Vijitha Kumara]

If your query is complete then it should end with ";" (colon), then it'll be executed.

[Niranjan Deshpande]

Thanks for the ; thing! But now I am getting this:

   
mysql> create user admin adminadmin;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'admin
admin' at line 1

[Renjith Mohan]

Please check if you have left out any white spaces in the password.

Also, grant privileges on mysql server using the command

GRANT ALL ON *.* TO username@host; // run the command after logging into mysql prompt


Renjith

[Niranjan Deshpande]

There are now white spaces

I even used the command create user admin identified by adminadmin

What the hell is wrong!

[Niranjan Deshpande]

I finally used the root user

1.C:\Sun\AppServer\mysql\bin>mysqladmin -u root password root.

I referred this link for setting the password

2.C:\Sun\AppServer\mysql\bin>mysql -u root -p
Enter password: **** <- enter root here


Onnce I was able to pin down the user name and password, I changed the persistence.xml and successfully executed the application.

Thanks a lot for the help!

[Renjith Mohan]

All privileges are available if you are a root user.

Any way, good 2 know you solved