linux平台安装Mysql报错

阿咪 发布于 2011/05/05 17:12
阅读 1K+
收藏 2

安装过程:
[root@ibt syssoft]# rpm -ivh MySQL-server-5.1.56-1.glibc23.x86_64.rpm
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h ibt.com password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

Starting MySQL.Manager of pid-file quit without updating file.[FAILED]

简单安装都没有通过,报错 Starting MySQL.Manager of pid-file quit without updating file.[FAILED]
这是什么原因

[root@ibt ~]# uname -a
Linux ibt.com 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:14 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

加载中
0
清凌渡
清凌渡

记得在装MYSQL的时候,期间会切换到一个蓝底儿的界面,让你输入 root密码什么的。。

然后,其它也就没什么了,安装mysql从没出现过什么错误 。。

安装完之后,就可以直接敲mysql -u root -p 然后根据提示输入密码,就可以进入mysql控制台了。。

0
G.
G.

用源代码安装咯...

0
逝水fox
逝水fox

查看一下 /etc/my.cnf 文件指定的pid是写在哪里的 看一下是什么原因造成没法写入文件吧

0
阿咪
阿咪

110506  9:38:24 [ERROR] Plugin 'InnoDB' init function returned error.
110506  9:38:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
^G/usr/sbin/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
日志报错

my.cnf配置文件

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /var/lib/mysql/mysql.sock

# The MySQL server
[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
#skip-locking
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
innodb_buffer_pool_size=2G

#skip-networking

# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# but will not function as a master if omitted
server-id       = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

0
m
mavica

/usr/sbin/mysqld: Disk is full writing

磁盘不够?没权限?

0
星满天

这个时候我们需要find /usr -name mangager和mysqld_safe,找到这两个文件后, mkdir /var/lib/bin(这个bin文件不存在),然后将这两个文件cp到这个bin文件里面。

之后再运行service mysql restart就OK了

www.dabaicong.com,哈哈,我前两天才写的 。也是同样的问题,百度之,找到了,然后就写了这么个东西 

OSCHINA
登录后可查看更多优质内容
返回顶部
顶部