Lighting Up MySQL
Now that BlueDragon is lit, I need to get MySQL going. Back when I did my other Linux server, I picked up the excellent book MySQL Bible (with CDROM!), by Steve Suehring. As an aside, I do not find the suffix "...Bible" offensive on books. Why? Becaue the Bible is not called "Bible", it is called "Holy Bible", or better stated, Book of Holiness. So, I have the MySQL Bible for things MySQL, and the Holy Bible for things Holy. Clearly, though, the Holy Bible is far more important.
Right now, though, I'm sure you are interested in the MySQL stuff, though. I don't want to take too much away from the book, so if you click the links and buy yourself a copy, you'll get what is IMHO a fantastic book on MySQL, and SQL in general.
Well anyway, here is the short version. I ain't gonna spell it out for you this time cuz' I'm really gunning for you to buy the book and dump a few cents into my Amazon account as a result. Here is the short version:
Use the mysqladmin command to provide a password for the root MySQL account
Use the mysql command to log in with the root account
Create a new user account, and grant that user 'do anything' permissions so you can avoid using the root account for regular maintenance
Create a database
Grant the new account permission to the database
Get out of mysql and go back in, logging in with the new user account you made.
See if you can get into the database you made. Mind you, I presume you know enough SQL to do stuff like SELECT statements an' all. If not, you can get SQL help by googling around.
At this stage, I got MySQL lit up, so I'm happy.
(2 minutes later)
Not happy.
I go to the BlueDragon admin page, go to add the datasource, and get this:
The driver org.gjt.mm.mysql.Driver could not be found or was invalid
So now what to do? I'll google around.
Looks like I need something called MySQL Connector/J, which is the JDBC connector for MySQL. Makes sense.
I download it.
And how do I install this stupid thing? I ain't no Linux guru, not yet, at least.
I dig into the BlueDragon docs, and read that due to licensing restrictions, they can no longer bundle the MySQL JDBC driver, but I can get info on installing it here.
Fine.
I follow the instructions on the site, and they are rather simple. After that, I rebooted the server (I had the time), and after it came back to life, I went into the BlueDragon admin page. I added in a MySQL datasource, and it connected fine. I verified the datasource, and it.. failed! "Access for user ...@(servername) denied." When I created the MySQL user account, I named it ...@localhost. My mistake. I made a new account named with the @(servername) suffix, and wah-lah, BlueDragon verified the DSN.
Now to see about getting Apache tied in...
