Forum Problems Installing LAMS: java.sql.SQLException:


 
You may request notification for java.sql.SQLException:.
Search: 

1: java.sql.SQLException:
06/18/10 06:28 AM
[ Reply | Forward ]
Please advise how to resolve the below issue.

java.sql.SQLException: Access denied for user 'root'@'localhost'

Thanks in advance

Gopinath.M

Posted by gopinath mohanraj

2: Re: java.sql.SQLException:
In response to 1 06/18/10 07:31 PM
[ Reply | Forward ]
The MySQL root password password is incorrect. Check the lams.properties file and change the DB_ROOT_PASSWORD

See http://is.gd/cUPRO

Posted by Ernie Ghiglione

4: About java.sql.SQLException:
In response to 2 03/24/11 12:16 PM
[ Reply | Forward ]
Hi, i´m trying to install LAMS 2.3 in a windows 2008 "VPS", the mysql server have not a user "root", instead have a user called "psaclient", the server support team tells to me its imposible to have a user "root" on my server, there`s a way to select the name of my root user (psaclient)in the LAMS installer?
Thanks a lot for your help...

Posted by Juan Antonio López Martínez

Attachments:
5: Re: About java.sql.SQLException:
In response to 4 03/27/11 08:30 AM
[ Reply | Forward ]
Hmmm... I don't think we ever thought about this (a mysql server without root user).

So this is not good as you won't be able to use the Windows installer as in order to create the database, it assumes mysql has a root password.

Perhaps you can build LAMS from source?

Thanks,

Ernie

Posted by Ernie Ghiglione

6: About root user
In response to 5 03/30/11 08:43 AM
[ Reply | Forward ]
Thanks a lot.
I rebuilt LAMS and its online now...

Posted by Juan Antonio López Martínez

3: Re: java.sql.SQLException:
In response to 1 06/19/10 07:15 AM
[ Reply | Forward ]
Thanks yes , i finally resolve mysql-ds.xml file , root password was incorrect. after that i made changes it works well now.

Posted by gopinath mohanraj

Reply to first post on this page
Back to Problems Installing LAMS
.LRN Home