Tagged: MySQL Toggle Comment Threads | Keyboard Shortcuts

  • Jay Versluis 2:36 pm on February 16, 2014 Permalink | Reply
    Tags: , MySQL,   

    Categories: Plesk ( 70 )

    How to upgrade to MySQL 5.5 and PHP 5.4 in Plesk 11.5 (CentOS) 

    Plesk-LogoOne of my clients wanted to run a web application that required MySQL 5.5 instead of the default MySQL 5.1 that ships with Plesk at the time of writing. He needed it due to the better handling of UTF8 characters.

    I struggled to find clear instructions on how to do this – so here they are ๐Ÿ˜‰

    CentOS 5.x

    In CentOS 5 you can switch to MySQL 5.5 under Tools and Settings – Updates and Upgrades. The installer shows something like this:

    Screen Shot 2014-02-16 at 11.46.19

    Simply switch to MySQL 5.5 (packaged by Parallels) and hit install.

    CentOS 6.x

    Sadly the above convenience doesn’t exist in CentOS 6, so we’ll have to make use of the excellent Atomic repository again. In the past I’ve experienced instabilities in the way Plesk may react to non-standard repo packages – but it appears this is no longer an issue (or so I was told). Suffice to say proceed at your own risk and test, test and test again before using this in a production environment.

    Install access to the Atomic repo with this command:

    wget -q -O - http://www.atomicorp.com/installers/atomic | sh
    

    You’ll have to agree to some terms and conditions, after which you can simply use yum update to include some additional functionality that is not provided by CentOS or Parallels. Doing so will automatically update both MySQL and PHP for you.

    Restart the server when you’re finished for good measure.

    Check out the full article





     
    • Mihai 3:53 pm on February 25, 2016 Permalink | Reply

      Not worked here dunno why … other commands for centos 6 ? best regards

    • wblondel 9:07 pm on March 12, 2016 Permalink | Reply

      Thanks a lot for this guide ! It worked on CentOS 6.7 ๐Ÿ™‚

    • Gerard Dy 12:13 am on November 25, 2016 Permalink | Reply

      Hi Jay,

      If I want to upgrade to PHP 5.4+ only is that possible on CentOS 5.6 and Plesk 11.5.30? Do you have tutorials for that? Thanks.

      • Jay Versluis 7:55 am on November 25, 2016 Permalink | Reply

        Hi Gerard, yes it should be. It’s been a while since I’ve used CentOS 5 with Plesk 11.5, but from what I remember it’s as simple as installing the Atomic repo as described above, then issue “yum update php” and hopefully see a new version appear. Good luck!

  • Jay Versluis 4:21 pm on April 22, 2012 Permalink | Reply
    Tags: , , MySQL   

    Categories: Linux, MySQL ( 96 )

    How to install MySQL on CentOS 

    This is a step-by-step guide of what you need to do in order to install and setup MySQL on a new server.

    We’ll prepare a fresh CentOS 6 system (64 bit) for use as a database server. All you need is access to an SSH client and your server root credentials.

    (More …)





     
  • Jay Versluis 6:33 pm on November 6, 2009 Permalink | Reply
    Tags: , MySQL   

    Categories: How To ( 30 )

    How to install MySQL on CentOS 

    Assuming you’d like to run WordPress on your very own vanilla CentOS system, open a terminal window and do the following:

    yum install php-mysql mysql mysql-server
    /sbin/chkconfig --levels 235 mysqld on
    /etc/init.d/mysqld start
    

    You have to be logged on as root to do this.

    The next thing you probably want to do is create a database so you can run WordPress on it. As you may know, we need phpMyAdmin to do this, so we’ll install that next:

    yum install phpmyadmin

    In case it doesn’t work, phpmyadmin is available from EPEL or RPM Forge – check out this article if you haven’t got it on your system.

    Now we need to restart apache so it’ll know about his new companion:

    service httpd restart

    Excellent! We’re getting there. Now let’s create that database….

    Well, I’m stuck here! I’ll let you know when I’ve figured it out. Until then, happy googling ๐Ÿ˜‰





     
c
compose new post
j
next post/next comment
k
previous post/previous comment
r
reply
e
edit
o
show/hide comments
t
go to top
l
go to login
h
show/hide help
shift + esc
cancel