Solaris下MySQL的安装:
1.Solaris下的MySQL目录:
/usr/sfw/sbin:守护进程mysqld,mysqld_safe
/usr/sfw/bin:管理工具mysqladmin,mysqlcheck等
/usr/sfw/share/mysql/:配置文件 my-medium.cnf等
2.配置MySQL配置文件
-bash-3.00#cp /usr/sfw/share/mysql/my-medium.cnf /etc/my.cnf
-bash-3.00#vi /etc/my.cnf
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
##Modified content MartriWang@gmail.com
#socket = /var/lib/mysql/mysql.sock
socket = /home/mysql/5.0/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
#socket = /var/lib/mysql/mysql.sock
##Modified content MartriWang@gmail.com
socket = /home/mysql/5.0/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
3.创建mysql用户
-bash-3.00#useradd -u 1002 mysql
-bash-3.00#groupadd -g 1002 mysql mysql
-bash-3.00#mkdir /export/home/mysql
4.启动mysql
-bash-3.00#./mysqld &
发生如下错误:
080424 15:45:53 InnoDB: Started
080424 15:45:53 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
080424 15:45:53 Aborting
解决方法:
rm -rf /pathtodatadir
then
cd /usr/local/mysql1/bin
./mysql_install_db --user=mysql --ldata=/var/mysql
./mysqld_safe --datadir=/var/mysql --user=mysql &
5.安装成功
备份:[root@MT src]#mysqldump -u root -p --opt mysql > mysql_back
恢复:[root@MT src]#mysql -u root -p mysql < mysql_back
1.Solaris下的MySQL目录:
/usr/sfw/sbin:守护进程mysqld,mysqld_safe
/usr/sfw/bin:管理工具mysqladmin,mysqlcheck等
/usr/sfw/share/mysql/:配置文件 my-medium.cnf等
2.配置MySQL配置文件
-bash-3.00#cp /usr/sfw/share/mysql/my-medium.cnf /etc/my.cnf
-bash-3.00#vi /etc/my.cnf
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
##Modified content MartriWang@gmail.com
#socket = /var/lib/mysql/mysql.sock
socket = /home/mysql/5.0/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
#socket = /var/lib/mysql/mysql.sock
##Modified content MartriWang@gmail.com
socket = /home/mysql/5.0/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
3.创建mysql用户
-bash-3.00#useradd -u 1002 mysql
-bash-3.00#groupadd -g 1002 mysql mysql
-bash-3.00#mkdir /export/home/mysql
4.启动mysql
-bash-3.00#./mysqld &
发生如下错误:
080424 15:45:53 InnoDB: Started
080424 15:45:53 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
080424 15:45:53 Aborting
解决方法:
rm -rf /pathtodatadir
then
cd /usr/local/mysql1/bin
./mysql_install_db --user=mysql --ldata=/var/mysql
./mysqld_safe --datadir=/var/mysql --user=mysql &
5.安装成功
备份:[root@MT src]#mysqldump -u root -p --opt mysql > mysql_back
恢复:[root@MT src]#mysql -u root -p mysql < mysql_back