Solaris下MySQL的安装

最新推荐文章于 2021-02-22 01:57:14 发布

原创最新推荐文章于 2021-02-22 01:57:14 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #solaris #buffer #server #table #cache

服务器技术专栏收录该内容

5 篇文章

订阅专栏

本文详细介绍在Solaris操作系统中安装MySQL的过程，包括配置文件的修改、MySQL用户的创建及常见错误处理方法。此外，还提供了MySQL备份与恢复的具体步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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