-
1. Re: problem with mysql can't find jboss database
peterj Jul 14, 2008 11:45 AM (in response to mikephoenix)This error means that your MySQL server does not have a database called "jboss". You will have to.create that database (using MySQL tools), and probably create the user and password that will be used for that database.
Here are the mysql statements I usually use to do this:
CREATE DATABASE dddd;
GRANT ALL PRIVILEGES ON xxx.* TO 'uuuu'@'localhost' IDENTIFIED BY 'pppp' WITH GRANT OPTION;
where dddd is the database name (jboss in your case), uuuu is the user name and pppp is the password. These values must match the values used in the *-ds.xml file that defines the datasource. -
2. Re: problem with mysql can't find jboss database
mikephoenix Jul 14, 2008 12:14 PM (in response to mikephoenix)Thanks Peter. I guess that I should have a little more specific in that I know that it is telling me that the jboss database wasn't created. I just thought that I might need something special in the way of tables or configuration of the jboss database. Anyhow, i'll try just dreting the database and see what happens.
-
3. Re: problem with mysql can't find jboss database
peterj Jul 14, 2008 12:28 PM (in response to mikephoenix)If the database is for the JBossAS services (the DefaultDS data source), the services will create the necessary tables themselves.
If the database is for your app, then it depends on your app. -
4. Re: problem with mysql can't find jboss database
mikephoenix Jul 14, 2008 12:52 PM (in response to mikephoenix)It's the JBossAS services. I just created it as you suggested and everything is working fine now. Thanks so much for your help.