0
votes
0answers
50 views

server pid removed after config cnf

i want config my server with this configuration : [mysql] # CLIENT # port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] # GENERAL # user ...
1
vote
1answer
302 views

How to Install and Run multiple MySQL Servers versions on centos? [closed]

I am new to MySQL database and I would like to install and run multiple MySQL server versions in CentOS server. I have done following things but no luck. Installed mysql 5.1.86 with default ...
0
votes
2answers
546 views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
0
votes
2answers
1k views

Create a super user in MySQL 5.5 not working: Permission denied for root@localhost

Using CentOS 6, logged in to MySQL as root, entering the command: create user 'user123' identified by 'pass123'; works fine. But when I try and give that user super user privileges with: grant ...
1
vote
3answers
4k views

Install MySQL 5.6 on CentOS 6.3 gone WRONG

I am trying to install MySQL 5.6 on CentOS 6.3 64bit using the .rpms provided by MySQL. I downloaded all the 64bit linux rpms into /usr/local/src/mysql and performed rpm -Uvh *. The installation gave ...
1
vote
2answers
3k views

Upgrading MySQL 5.5 to 5.6

I've decided to do the update of MySQL from 5.5 to 5.6 on my CentOS server. How can I backup MySQL5.5 in case I want to downgrade, and how can I install MySQL 5.6? Is there a way to use yum for ...
1
vote
3answers
2k views

How to upgrade mysql5.0 to 5.5 on CentOS

I am trying to upgrade mysql from 5.0 to 5.5 on my local server. I have CentOS 5.8. I have php5.3 installed. When I type yum remove mysql mysql-* The following comes out. Removing: mysql ...
4
votes
2answers
4k views

MySQL 5.1 vs MySQL 5.5 (5.1 twice as fast)

I recently installed MySQL 5.1 on CentOS 6.2 and had a performance gain over the MySQL 4.1 we are running. So I upgrade the MySQL 5.1 to MySQL 5.5 to see if there was even more of a gain but it ...
2
votes
1answer
535 views

MySQL 5.5 on CentOS 6 — mysql user 'root@localhost' cannot grant privs

This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and . I know the password is correct as I can log in with root@localhost to the mysql server and can also create ...