我用xshell连到centos服务器上安装mysql,最后要启动服务的时候,执行 /usr/local/mysql/bin/mysqld_safe --user=root 显示两行之后不动了,没法往下走了。。-bash-3.2# /usr/local/mysql/bin/mysqld_safe --user=root
120925 20:22:04 mysqld_safe Logging to '/usr/local/mysql/var/localhost.localdomain.err'.
120925 20:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var然后我开另一个窗口,执行下面脚本,就报错:-bash-3.2# /usr/local/mysql/share/mysql/mysql.server start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]这如何解决? 非常感谢!
120925 20:22:04 mysqld_safe Logging to '/usr/local/mysql/var/localhost.localdomain.err'.
120925 20:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var然后我开另一个窗口,执行下面脚本,就报错:-bash-3.2# /usr/local/mysql/share/mysql/mysql.server start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]这如何解决? 非常感谢!
解决方案 »
- 这是什么错误,
- 关于in和exists的优化问题,搜索无准确结果,在MYSQL
- mysql远程登录问题 如何对外开启3306端口
- linux下安装mysql的问题
- MySql中怎么建立联合主键~!?~~
- vb6中不能批量更新MYSQL数据库的问题.
- 请教关于null的问题?
- 我这样用lock table有什么问题呢?正确的应该怎么用啊?
- 建立一个C/S模式的应用,server端是否可以使用国外的某些免费空间?比如一些支持php/mysql的空间?
- mysql主从同步卡住的问题~
- 如果解决Cannot get a connection, pool error Timeout waiting for idle object
- 如用一条语句 将10003到10005之间的valid改成0
另外用rpm包安装很简单的
120925 20:05:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120925 20:05:32 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
120925 20:05:32 [Note] Event Scheduler: Loaded 0 events
120925 20:05:32 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.56-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
120925 20:14:56 mysqld_safe A mysqld process already exists
120925 20:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120925 20:22:04 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
120925 20:22:04 [Note] Event Scheduler: Loaded 0 events
120925 20:22:04 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.56-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
将我安装成功的步骤贴给你,你试试看
# ll
total 28652
-rw-r--r-- 1 root root 5517977 Aug 7 12:01 cmake-2.8.6.tar.gz
-rw-r--r-- 1 root root 23774015 Aug 7 12:02 mysql-5.5.22.tar.gz
mysql的安装
A.建立mysql用户以及mysql组
# groupadd mysql
# useradd -g mysql mysql
B.创建mysql数据库的相关目录,并且赋予权限
# mkdir -r /database/mysql
# mkdir /data/mysql -p
# mkdir /etc/mysql# chown mysql.mysql /database/mysql
# chown mysql.mysql /etc/mysql
# chown mysql.mysql /data/mysql
# chmod 755 /data/mysql -R
# chmod 755 /etc/mysql
# chmod 755 /database/mysql#cmake -DCMAKE_INSTALL_PREFIX=/database/mysql \
-DMYSQL_DATADIR=/data/mysql/ \
-DSYSCONFDIR=/database/mysql/ \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/etc/mysql/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_USER=mysql
我上面的版本较高,你的版本应该不用安装cmake,直接make 就可以
120925 20:22:04 mysqld_safe Logging to '/usr/local/mysql/var/localhost.localdomain.err'.
120925 20:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var这时候,我再打开一个xshell窗口B连上去,执行/usr/local/mysql/bin/mysql -u root -p 可以连进mysql,可以正常使用。如果在A窗口用Ctrl+Z终止 /usr/local/mysql/bin/mysqld_safe --user=root 进程,B窗口就用不了mysql了, 执行/usr/local/mysql/bin/mysql -u root -p 会提示找不到 /tmp/mysql.sock 。
/usr/local/mysql/bin/mysqld_safe& --user=root不然, ctrl + z会把这个进程杀死。
你的mysql实际上已经正常启起来了。
你的MYSQL已经正常启动了?建议你尝试连接一下。
120925 20:22:04 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.检查进程中MYSQLD是否在运行,连接试试