Install MySQL 5.5.37 on Fedora 18/17, CentOS/Red Hat (RHEL) 6.5/5.10

MySQL Logo

Are you looking MariaDB 5.5.37/10.0 Install guide?

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest and greatest version 5.5.37 on Fedora 18/17/16/15/14/13/12, CentOS 6.5/6.4/6.3/6.2/6.1/6/5.10 and Red Hat (RHEL) 6.5/6.4/6.3/6.2/6.1/6/5.10.

Note: If you are upgrading MySQL (from earlier version), then make sure that you backup (dump and copy) your database and configs. And remember run mysql_upgrade command.

Install MySQL Database 5.5.37 on Fedora 18/17/16/15/14/13/12, CentOS 6.5/5.10, Red Hat (RHEL) 6.5/5.10

1. Change root user

su -
## OR ##
sudo -i

2. Install Remi repository

Fedora

## Remi Dependency on Fedora 18, 17, 16
rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm 
rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
 
## Fedora 18 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm
 
## Fedora 17 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-17.rpm
 
## Fedora 16 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm
 
## Fedora 15 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-15.rpm
 
## Fedora 14 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm
 
## Fedora 13 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-13.rpm
 
## Fedora 12 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-12.rpm

CentOS and Red Hat (RHEL)

## Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
 
## CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
 
 
## Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 ##
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
 
## CentOS 5 and Red Hat (RHEL) 5 ## 
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

3. Check Available MySQL versions

Fedora 18, 17, 16, 15, 14, 13, 12

yum --enablerepo=remi list mysql mysql-server

CentOS 6.4/6.3/6.2/6.1/6/5.9 and Red Hat (RHEL) 6.4/6.3/6.2/6.1/6/5.9

yum --enablerepo=remi,remi-test list mysql mysql-server

Output:

Loaded plugins: changelog, fastestmirror, presto, refresh-packagekit
...
remi                                                            | 3.0 kB     00:00     
remi/primary_db                                                 | 106 kB     00:00     
Available Packages
mysql.i686                               5.5.37-1.fc18.remi                        @remi
mysql-server.i686                        5.5.37-1.fc18.remi                        @remi

4. Update or Install MySQL 5.5.37

Fedora 18, 17, 16, 15, 14, 13, 12

yum --enablerepo=remi install mysql mysql-server

CentOS 6.5/6.4/6.3/6.2/6.1/6/5.10 and Red Hat (RHEL) 6.5/6.4/6.3/6.2/6.1/6/5.10

yum --enablerepo=remi,remi-test install mysql mysql-server

5. Start MySQL server and autostart MySQL on boot

Fedora 18/17/16

systemctl start mysqld.service ## use restart after update
 
systemctl enable mysqld.service

Fedora 15/14/13/12/11, CentOS 6.5/6.4/6.3/6.2/6.1/6/5.10 and Red Hat (RHEL) 6.5/6.4/6.3/6.2/6.1/6/5.10

/etc/init.d/mysqld start ## use restart after update
## OR ##
service mysqld start ## use restart after update
 
chkconfig --levels 235 mysqld on

6. MySQL Secure Installation

  • Set (Change) root password
  • Remove anonymous users
  • Disallow root login remotely
  • Remove test database and access to it
  • Reload privilege tables

Start MySQL Secure Installation with following command

/usr/bin/mysql_secure_installation

Output:

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
 
 
In order to log into MySQL to secure it, we\'ll need the current
password for the root user.  If you\'ve just installed MySQL, and
you haven\'t set the root password yet, the password will be blank,
so you should just press enter here.
 
Enter current password for root (enter for none): 
OK, successfully used password, moving on...
 
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
 
Set root password? [Y/n] Y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!
 
 
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.
 
Remove anonymous users? [Y/n] Y
 ... Success!
 
Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.
 
Disallow root login remotely? [Y/n] Y
 ... Success!
 
By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.
 
Remove test database and access to it? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!
 
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
 
Reload privilege tables now? [Y/n] Y
 ... Success!
 
Cleaning up...
 
 
 
All done!  If you\'ve completed all of the above steps, your MySQL
installation should now be secure.
 
Thanks for using MySQL!

Note: If you don’t want some reason, do a “MySQL Secure Installation” then at least it’s very important to change the root user’s password

mysqladmin -u root password [your_password_here]
 
## Example ##
mysqladmin -u root password myownsecrectpass

7. Connect to MySQL database (localhost) with password

mysql -u root -p
 
## OR ##
mysql -h localhost -u root -p

8. Create Database, Create MySQL User and Enable Remote Connections to MySQL Database

This example uses following parameters:

  • DB_NAME = webdb
  • USER_NAME = webdb_user
  • REMOTE_IP = 10.0.15.25
  • PASSWORD = password123
  • PERMISSIONS = ALL
## CREATE DATABASE ##
mysql> CREATE DATABASE webdb;
 
## CREATE USER ##
mysql> CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123';
 
## GRANT PERMISSIONS ##
mysql> GRANT ALL ON webdb.* TO 'webdb_user'@'10.0.15.25';
 
##  FLUSH PRIVILEGES, Tell the server TO reload the GRANT TABLES  ##
mysql> FLUSH PRIVILEGES;

Enable Remote Connection to MySQL Server –> Open MySQL Port (3306) on Iptables Firewall (as root user again)

1. Edit /etc/sysconfig/iptables file:

nano -w /etc/sysconfig/iptables

2. Add following INPUT rule:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

3. Restart Iptables Firewall:

service iptables restart
## OR ##
/etc/init.d/iptables restart

4. Test remote connection:

mysql -h dbserver_name_or_ip_address -u webdb_user -p webdb
Follow If Not True Then False Updates!

236 Comments

  1. Hey there JR every time i try to start the mysql server i get “Job failed. See system logs and ‘systemctl status’ for details.”
    Im running Fedora 16 64Bit, thanks in advanced.

    • Hi Random,

      Could you post output of following commands (example to http://pastebin.com) after you ty to start mysql-server:

      systemctl status mysql.service
       
      tail -n 300 /var/log/messages
       
      tail -n 300 /var/log/mysqld.log
      • It is good installation process but It did not install dependencies of MySQL ??? Dont understand what to do I am not even getting library files in /usr/include/mysql and /usr/lib/

  2. hi JR,

    It is good installation process but It did not install dependencies of MySQL ??? Dont understand what to do I am not even getting library files in /usr/include/mysql and /usr/lib/

    • Hi Sanjog,

      Could you post output of following commmands:

      uname -a
       
      lsb_release -a
       
      yum list installed \*mysql\*
      • Hey JR Its working fine. now my next task is to connect to mysql database through a C program. If i dont get any thing will come back to you.

        • Excellent! :) Feel free to ask, if you have any questions.

  3. @Random
    Even I had the complaint of Job Failed to start in Fedora 16 (32 bit). I updated systemd using yum (yum update systemd) and the mysql worked.

    • Thanks a lot Vijay! I spent entire evening trying to figure out the problem but your comment solved my problems :)
      again Thanks!

  4. I don’t think you should be getting anything in the lib until you’ve done something with mysql. Such as creating a database or at least some users. Also, if you really screwed up a previous installation like I have, yum won’t remove the /var/lib/mysql folder (at least, it didn’t for me).

    I used this method to attempt reinstalling it several times over, and it failed each time. If you go and delete it manually as root, and then perform the above steps again, it should work.

  5. Hi,

    i did each step of this tutorial under Fedora 17 KDE (which is in VMWare workstation as guest machine) and i can’t access from my host machine (windows 7) to MySQL database (which is on Fedora).

    during the whole installation process i had no error or warning.

    so where is the problem ?
    thx

    • Hi alain,

      Do you have own ip address on Fedora? And did you used your Windows 7 ip address when you created user and granted permissions?

  6. Thanks a lot
    was really helpful updating my server
    God Bless

  7. rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm

    failed 404.

    Release 6-8 is there though. Hope that works…..

    • Hi James,

      Nice note, thanks! I updated all guides to use latest epel-release-6-8.noarch.rpm version. :)

  8. Can u please give step for install Mysql 5.6 ?

    • Hi Bhavesh,

      Not yet, this style guide, but if you want to build MySQL 5.6 yourself, then it’s of course possible to install.

  9. Still i’m getting error
    Can’t Connect to mysql on ‘Localhost ip’ (113)

    i’m using Cent OS 6.3

    • Hi Kartik,

      Could you post full mysql command and error?

  10. Hi, this post is great but my problem is this line
    #mysqladmin -u root password my_pass
    mysqladmin: connect to server at ‘localhost’ failed
    error: ‘Access denied for user ‘root’@'localhost’ (using password: NO)’

    what is the solution ?

    • Hi Kürşat,

      Do you try to change root password?

      You will need use old root password when you connect to MySQL server, like:

      ## Password prompt ##
      mysqladmin -u root -p password my_new_pass
       
      ## Password as a parameter (note: no space between -p and old pass) ##
      mysqladmin -u root -pmy_old_pass password my_new_pass
  11. when i tipe in the last command the output is the following: error 2003 (HY000) can´t connect to mysql server on ’10.0.15.25′ (110)

  12. plz update to Mysql 5.6 is not GA.

  13. can you tell me how to do it please? because when i use yum update the output says that there are no packages available for update

    • Hi MB,

      This is just example row, you have to use your real ip address, which might be something totally different that 10.0.15.25.

      • okay thank you :)

  14. okay thank you :)

  15. awsm! i was setting my own rackspace centos 5.9 cloud server, and this article really got me over the line with getting my LAMP stack going. great repo! great post!

  16. yeah,very tks!

  17. Hello! I followed your instruction and I get this error when connecting remotely.

    ERROR 2003 (HY000): Can’t connect to MySQL server on ‘ip-address’ (113)

    • Hi Ryan,

      First few questions.

      What OS you use?
      Is your MySQL installation working normally from localhost?
      Did you opened MySQL port on Iptables?
      How did you created MySQL user?

  18. Hey, i’m doing a project where i’m trying to install a blog, but first I need MySQL, Apache, WordPress, and php-mysql.

    When doing #7 Connect to MySQL I get this error:

    ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

    All the help I can get will be great! Project submission is coming fast.

    • Hi Josh,

      Is your MySQL server running?

      • I was actually able to fix the problem i was having here. To be honest, i completely forgot what i did to fix it because i did it about 10+ hours ago.

        I’m very new to this, and have almost no experience. I’m doing this as a school project using VMWare in a Fedora 18 core and literally have no clue what i’m doing with your tutorial and notes.

        I do have another problem though.
        I tried to do:
        service httpd restart and was told to see ‘systemctl status httpd.service’ and ‘journalctl -n’ for details.

        The last command that I did that DID work was the yum –enablerepo=remi,remi-test install httpd php php-common.

        I then typed “/etc/init.d/httpd start” and was told there was no file or directory, so i did ls -l /etc/init and saw “/etc/init.d -> rc.d/init.d”

        So then i did service httpd start and it said “redirecting to /bin/systemctl start httpd.service”

        I then did “systemctl enable httpd.service” and didn’t receive any error message so i assumed that it worked.

        I then went on to the test page portion, and typed “/var/www/html/test.php” and added <?php and phpinfo(); to the page, like you said on the apache web page tutorial (sorry it's for the apache site).

        So, when I went to my browser to check it, i didn't receive anything but a "oops. google chrome could not connect to local host." — Is this because i'm using VMWare?

        So i went to look at other comments to see what was there, and followed your directs under Priyabrata to type httpd -t for any syntax errors, and now i'm stuck at this point.

        I get this error/message:
        http: syntax error on line 56 of /etc/httpd/conf/httpd.conf: Syntax error on line 6 of /etc/httpd/conf.modules.d/10-php.conf: Cannot load modules/libphp5.so in to server: /etc/httpd/modules/libphp5.so: symbol SSLeay_version, version OPENSSL_1.0.1 not defined in file libcrypto.so.10 with link time reference

        I have no idea what i'm doing or how to fix this. I still have to finish this stuff in order to start my project that I found on this site:
        http://www.tuxradar.com/content/nine-linux-projects-90-minutes and it's Project 5: Blog from Home.

        I appreciate all the time, effort and help you are giving me in order to solve my problems. If it's as easy and simple as i'm not able to do it in VMWare, do you have another idea for A project I could do in a couple of days worth of time? :D

  19. Yes, i believe so, but my “/etc/init.d/httpd start” isn’t working. Says there’s no such file or directory.

  20. Hi,
    I had the same problem

    I get this error/message:
    http: syntax error on line 56 of /etc/httpd/conf/httpd.conf: Syntax error on line 6 of /etc/httpd/conf.modules.d/10-php.conf: Cannot load modules/libphp5.so in to server: /etc/httpd/modules/libphp5.so: symbol SSLeay_version, version OPENSSL_1.0.1 not defined in file libcrypto.so.10 with link time reference

    Do this:

    yum update openssl

  21. Good Solution~~~ Thank you….

  22. can u solve this error
    [root@localhost Desktop]# service mysql start
    Starting MySQL………………………………………………………………… SUCCESS!
    [root@localhost Desktop]# mysqladmin -u root password pinkuupadhyay
    mysqladmin: connect to server at ‘localhost’ failed
    error: ‘Access denied for user ‘root’@'localhost’ (using password: NO)’
    [root@localhost Desktop]# mysql -u root -p
    Enter password:
    ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
    [root@localhost Desktop]# mysql -u root -p
    Enter password:
    ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES)
    [root@localhost Desktop]# mysql -h localhost -u root -p
    Enter password:
    ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES)
    [root@localhost Desktop]#

    • Hi shaurabh,

      So what password you used on last two attempts?

  23. Thank you for this tutorial. Did this installation many times already, but it is always good to have a tutorial like this that can be followed.

  24. It worked like a charm! :D Thank you VERY much!

    Bye from
    Portugal

  25. I followed the instructions and have according to that I have MySQL 5.5.36 server installed, however the client still shows up as 5.1.73 inside phpMyAdmin. phpMyAdmin gives me a warning message:

    Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.5.36. This may cause unpredictable behavior.

    How can I fix that? Please someone give me a solution. Thank you!

    • Hi Martin,

      Could you post output of following command:

      rpm -qa mysql\*
  26. Hi JR,

    Here is what I get.

    # rpm -qa mysql\*
    mysql55w-5.5.36-3.w6.x86_64
    mysql55w-libs-5.5.36-3.w6.x86_64
    mysql55w-server-5.5.36-3.w6.x86_64

Add Comment Register



Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackbacks/Pingbacks

  1. Install MySQL 5.1 (5.1.49) on Fedora 13, CentOS 5.5, Red Hat (RHEL … | mysql - [...] artykuł: Install MySQL 5.1 (5.1.49) on Fedora 13, CentOS 5.5, Red Hat (RHEL … a-server-providing, fedora, greatest-version, …
  2. Creando una base de datos en MySQL para conectar con Haskell | Sólo para Mí! - [...] rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) Fuente: http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/ [...]