Fedora :: Installing And Setup Mysql With Fedora 14

To install mysql follow this process. Go to your Terminal and Enter the command given below:

Code:

After installation you need to start mysql server by

Code:

After this you need to enter this command

Code:

1.First you system will ask you old mysql root password if you have installed mysql just now and not set password yet then you can enter anything or just press enter.

2. After that system will ask you twice for new password you can set a new password or you can keep it blank for no root password. I will suggest you to enter a password.

3.remove anonymous user? make it yes when you install mysql an automatic mysql user has created so remove it.

4. Disallow root login remotely. Hope you want to disallow mysql root login from remote for security of your mysql sever. If you want to use you can select no.

5. Remove test database. As anonymous user system generate and automatic database for testing.select yes to delete it.

6.Reload privileges: do yes to flush privileges.

Now you can login in your mysql server as root by this command

Code:

One more thing make sure that when you are entering this command you login your terminal as general user not as root.

Now you can create a new user by following commands.

To create databases

Code:

To see database list

Code:

Code:

Code:

Code:

Code:

Code:

If you want to work with mysql in gui mode Then you can install phpMyAdmin to install phpmy admin go to terminal and eter

Code:

And after completing installation you can login in to phpmyadmin. To login go to your browser enter [url] or Click here or you can download mysql gui client Mysql Work Bench from mysql website or Click here after installation it will be appear in programming menu. It's also cool client with mysql server activity watcher.