mysql upgrade not working
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.
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.