Installing and Setup mysql with Fedora 14

[DAKSH]

Updated with current Mariadb installation. Works with Fedora 26

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

su -
yum install mariadb-server

After installation you need to start mysql server by

service mariadb start

After this you need to enter this command

mysql_secure_installation

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

mysql -u root -p

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

show databases;

create user 'newdbusr'@'localhost' identified by 'newdbusrpassword';

to check mysql users

select user from mysql.user;

For permission

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

su -
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.

[dsmithhfx]

Hi,

I had no difficulty installing a lamp stack on FC 14, however I am having trouble with phpmyadmin. It doesn't seem to be loading my configured config.inc.php and so the pmadb features aren't working. Any hints on what the problem might be?

Thanks

[dsmithhfx]

OK I found that phpMyAdmin is loading /etc/phpMyAdmin/config.inc.php rather than /usr/share/phpMyAdmin/config.inc.php

Thanks for all your help!

[DAKSH]

Sorry I was busy to learn programming
You can do it by changing basedir.
Got to /etc/php.ini
find

open_basedir

make it

open_basedir = On

now go on /etc/http/conf/http.conf
if you are using virtual host
then find

<VirtualHost *:80>

after that. add a line like this

php_admin_value open_basedir /usr/share/phpMyAdmin:/home/user/public_html

[nzgunn]

Thank You for taking the time and thinking of others.