mysql启动不了

数据库服务和管理,MySQL/PostgreSQL/Oracle/Sybase 等
回复
头像
lmlm221
帖子: 169
注册时间: 2006-07-27 23:12
送出感谢: 0
接收感谢: 0

mysql启动不了

#1

帖子 lmlm221 » 2008-09-19 9:45

我是下载的源码手动编译安装的,不知道出这问题是怎么回事阿

代码: 全选

sudo ./mysql_install_db

Installing MySQL system tables...
080919  9:36:51 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
080919  9:36:51 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
OK
Filling help tables...
080919  9:36:51 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
080919  9:36:51 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/bin/mysqladmin -u root -h lmlm331-desktop password 'new-password'

Alternatively you can run:
/opt/mysql/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.

You can start the MySQL daemon with:
cd /opt/mysql ; /opt/mysql/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /opt/mysql/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[/size]
头像
lmlm221
帖子: 169
注册时间: 2006-07-27 23:12
送出感谢: 0
接收感谢: 0

#2

帖子 lmlm221 » 2008-09-19 10:36

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
还有,在mysql配置文件里显示的 /var/run/mysql /var/lib/mysql 在电脑上都不存在
回复

回到 “数据库管理”