I found there are no official installation process of mysql in fedora so I decided to post it in forum because It took an hour of digging to find the ultimate solutions.
To install mysql follow this process.
Go to your Terminal and
Enter the command given below
yum install mysql-server
After installation you need to start mysql server by
service mysqld start
After this you need to enter this command
no in here system will ask you several options.
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
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
create database mynewdb;
To see database list
create user 'newdbusr'@'localhost' identified by 'newdbusrpassword';
to check mysql users
select user from mysql.user;
grant alter, create, delete, drop, index, insert, select, update on mynewdb.* to 'newdbusr'@'localhost';
to check permissions
SHOW GRANTS FOR 'newdbusr'@'localhost';
To remove user
drop user 'newdbusr'@'localhost';
to drop database
drop database mynewdb;
Hope you will have no trouble for this
If you want to work with mysql in gui mode
Then you can install phpMyAdmin
to install phpmy admin go to terminal and eter
yum install phpmyadmin
and after completing installation you can login in to phpmyadmin. To login go to your browser enter "http://localhost/phpMyAdmin" 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.