Fedora Linux Support Community & Resources Center

Go Back   FedoraForum.org > Fedora Resources > Guides & Solutions (No Questions)
FedoraForum Search

Forgot Password? Join Us!

Guides & Solutions (No Questions) Post your guides here (No links to Blogs accepted). You can also append your comments/questions to a guide, but don't start a new thread to ask a question. Use another forum for that.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 27th November 2010, 10:24 PM
DAKSH Offline
Registered User
 
Join Date: Oct 2009
Location: In the Rain
Posts: 134
linuxfedorafirefox
Wink Installing and Setup mysql with Fedora 14

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
Code:
su -
yum install mysql-server
After installation you need to start mysql server by
Code:
service mysqld start
After this you need to enter this command
Code:
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
Code:
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
Code:
create database mynewdb;
To see database list
Code:
show databases;
Code:
create user 'newdbusr'@'localhost' identified by 'newdbusrpassword';
to check mysql users
Code:
select user from mysql.user;
For permission
Code:
grant alter, create, delete, drop, index, insert, select, update on mynewdb.* to 'newdbusr'@'localhost';
to check permissions
Code:
SHOW GRANTS FOR 'newdbusr'@'localhost';
To remove user
Code:
drop user 'newdbusr'@'localhost';
to drop database
Code:
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
Code:
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.

Last edited by DAKSH; 28th November 2010 at 12:24 AM.
Reply With Quote
  #2  
Old 7th December 2010, 10:42 AM
dsmithhfx Offline
Registered User
 
Join Date: Apr 2008
Posts: 90
linuxfedorafirefox
Re: Installing and Setup mysql with Fedora 14

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
Reply With Quote
  #3  
Old 8th December 2010, 02:35 AM
dsmithhfx Offline
Registered User
 
Join Date: Apr 2008
Posts: 90
linuxfedorafirefox
Re: Installing and Setup mysql with Fedora 14

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!
Reply With Quote
  #4  
Old 9th December 2010, 08:30 PM
DAKSH Offline
Registered User
 
Join Date: Oct 2009
Location: In the Rain
Posts: 134
linuxfedorafirefox
Re: Installing and Setup mysql with Fedora 14

Sorry I was busy to learn programming
You can do it by changing basedir.
Got to /etc/php.ini
find
Code:
open_basedir
make it
Code:
open_basedir = On
now go on /etc/http/conf/http.conf
if you are using virtual host
then find
Code:
<VirtualHost *:80>
after that. add a line like this
Code:
php_admin_value open_basedir /usr/share/phpMyAdmin:/home/user/public_html
Reply With Quote
  #5  
Old 12th June 2011, 08:09 AM
nzgunn Offline
Registered User
 
Join Date: Jun 2011
Posts: 1
windows_vistaie
Re: Installing and Setup mysql with Fedora 14

Thank You for taking the time and thinking of others.
Reply With Quote
Reply

Tags
install, mysql, setup

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
installing mysql 5.1 on fedora 8 ?? santhoshsd Using Fedora 1 15th September 2009 02:26 PM
Mysql Root password. Impossible to setup in Fedora 9 whitecloud1 Servers & Networking 2 11th January 2009 07:01 PM
mysql setup on Fedora 9 binu305 Servers & Networking 6 9th July 2008 07:35 AM
fedora core4 mysql root password setup leoleMCH Installation, Upgrades and Live Media 1 10th February 2006 02:45 PM
How do i setup phpmyadminand mysql with fedora? zood Using Fedora 6 9th July 2005 12:14 AM


Current GMT-time: 03:27 (Wednesday, 23-07-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat