Get started with MySql

Getting started with MySQL is really easy. First you want to install the mysql server. Then you can start the server with this command:

Code:

sudo /etc/init.d/mysql start

Then, because intially the root user has no password, we want to set the password like this:

Code:

mysqladmin -u root password myPassword

You can now login to the mysql server with this:

Code:

mysql -u root -p

You'll need to type in the password that you entered earlier.

Every new MySQL install has 2 databases: mysql and test. Do NOT screw up your mysql database because here is where all the permission and user info is. The test DB is for you to play around with. As was mentioned earlier the MySQL documentation is excellent. That's the main reason I prefer it over the other 2 mentioned above (maybe their docs are better nowadays.) You'll probably want to set up a new user next. The MySQL docs can help you there.

You mentioned that you're familiar with SQL, so you should be able to play around now.

Chris