mysql 如何重装

lwj1435

截取mysql重装，还是有这个错误
ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).

lwj1435

tar (child): mysql-5.5.37.tar.gz: Cannot open: No such file or directory
tar (child): Error is not recoverable: exiting now
tar: Child returned status 2
tar: Error is not recoverable: exiting now
./mysql-install-again.sh: line 8: cd: mysql-5.5.37/: No such file or directory
./mysql-install-again.sh: line 9: /mysql-openssl.patch: No such file or directory
CMake Error: The source directory "/root" does not appear to contain CMakeLists.txt.
Specify --help for usage, or press the help button on the CMake GUI.
make: *** No targets specified and no makefile found.  Stop.
groupadd: group 'mysql' already exists
useradd: user 'mysql' already exists
cp: cannot stat `support-files/my-medium.cnf': No such file or directory
sed: can't read /etc/my.cnf: No such file or directory
./mysql-install-again.sh: line 18: [: =: unary operator expected
sed: can't read /etc/my.cnf: No such file or directory
Could not open required defaults file: /etc/my.cnf
Fatal error in defaults handling. Program aborted
Installing MySQL system tables...
Could not open required defaults file: /etc/my.cnf
Fatal error in defaults handling. Program aborted

Installation of system tables failed!  Examine the logs in
/usr/local/mysql/var for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/mysql/bin/mysqld --skip-grant &

and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/mysql/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/mysql/var that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before submitting a bug report
at http://bugs.mysql.com/

cp: cannot stat `support-files/mysql.server': No such file or directory
ln: creating symbolic link `/usr/lib/mysql': File exists
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).
ln: creating symbolic link `/usr/bin/mysql': File exists
ln: creating symbolic link `/usr/bin/mysqldump': File exists
ln: creating symbolic link `/usr/bin/myisamchk': File exists
ln: creating symbolic link `/usr/bin/mysqld_safe': File exists
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).
ERROR! MySQL server PID file could not be found!
============================MySQL 5.5.26 install completed=========================
[root@localhost lnmp1.1-full]# /etc/init.d/mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).

lwj1435

这是第二次重装
groupadd: group 'mysql' already exists
useradd: user 'mysql' already exists
Installing MySQL system tables...
04:30:47 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 134092 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x40000
/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x76114e]
/usr/local/mysql/bin/mysqld(handle_fatal_signal+0x41a)[0x65573a]
/lib64/libpthread.so.0[0x376a80f710]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

Installation of system tables failed!  Examine the logs in
/usr/local/mysql/var for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/mysql/bin/mysqld --skip-grant &

and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/mysql/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/mysql/var that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before submitting a bug report
at http://bugs.mysql.com/

ln: creating symbolic link `/usr/lib/mysql': File exists
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mys
ln: creating symbolic link `/usr/bin/mysql': File exists
ln: creating symbolic link `/usr/bin/mysqldump': File exists
ln: creating symbolic link `/usr/bin/myisamchk': File exists
ln: creating symbolic link `/usr/bin/mysqld_safe': File exists
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mys
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mys
ERROR! MySQL server PID file could not be found!
============================MySQL 5.5.26 install completed======================

licess

提供mysql日志看看