mysql 常见问题 mysql.sock!!

azhoulinux

还有是我发现在/etc/my.cnf(这是我自己从share目录下拷贝的mysql目录文件，根据网上编译方法)，不过第一次运行mysql后，发现存在/etc/mysql/my.cnf，两个哪个是配置文件呢？

谢谢了，这段时间学习linux服务器内容，新手，请多多照顾！！

azhoulinux

# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/var) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

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

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

这是my.cnf,看看有什么不对吗？

azhoulinux

root@ubuntuer:/usr/local/mysql/bin# ./mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/ubuntuer.pid
060404 08:59:14  mysqld ended

我找了一下，/usr/local/mysql/var里面没有ubuntuer.pid(ubuntuer是主机名)

azhoulinux

debianer@ubuntuer:/usr/local/mysql/bin$ sudo ./mysql_install_db
Password:
Installing all prepared tables
Fill help tables

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:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h ubuntuer password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

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

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/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 https://order.mysql.com
debianer@ubuntuer:/usr/local/mysql/bin$ ./mysqld
mysqld_multi   mysqld_safe    mysqldump      mysqldumpslow
debianer@ubuntuer:/usr/local/mysql/bin$ sudo ./mysqld_safe &
[1] 8092
debianer@ubuntuer:/usr/local/mysql/bin$ Starting mysqld daemon with databases fr om /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/ubuntuer.pid
060404 09:10:46  mysqld ended


[1]+  Done                    sudo ./mysqld_safe
debianer@ubuntuer:/usr/local/mysql/bin$
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
数据库初始化没有错误，启动时有了错误，？？？？