MySQL Forums
Forum List  »  Install & Repo

mysql upgrade not working
Posted by: Paul Singleton
Date: August 27, 2014 12:04PM

I am trying to upgrade from 5.1 to 5.5 -- I do a chroot and it works on 5.1 but it is giving me some trouble on 5.5. When I start the server as follows i get:

/opt/mysql/mysql/bin/mysqld --no-defaults --user=mysql

140827 10:57:57 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140827 10:57:57 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140827 10:57:57 [Note] Server socket created on IP: '0.0.0.0'.

But when I do the same with the chroot:

/opt/mysql/mysql/bin/mysqld --no-defaults --user=mysql --chroot=/export/home/mysql/ --datadir=/data

140827 11:02:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140827 11:02:20 [ERROR] Can't create IP socket: Permission denied
140827 11:02:20 [ERROR] Can't start server: cannot resolve hostname!

I had in my my.cnf to put the socket in /tmp and there is a /tmp dir in my chroot that the mysql user has rw to. I cannot figure out what I need to change. Any help will be appreciated.

Options: ReplyQuote


Subject
Written By
Posted
mysql upgrade not working
August 27, 2014 12:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.