Solaris10安装Mysql

来源：互联网发布：手机淘宝如何查看积分编辑：程序博客网时间：2024/05/17 05:57

1.下载Solaris版Mysql

2.创建数据库管理用户

   # groupadd mysql
   # useradd -g mysql mysql
   # passwd mysql
   # mkdir /export/home/mysql
   # chgrp mysql /export/home/mysql
   # chown mysql /export/home/mysql
   # usermod -d /export/home/mysql mysql


3.mysql安装

   # gunzip mysql-standard-4.1.21-pc-solaris2.10-i386.pkg.gz
   # pkgadd -d mysql-standard-4.1.21-pc-solaris2.10-i386.pkg

4.数据库初始化

   # cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
   # cd /usr/local
   # ln -s /opt/mysql/mysql mysql
   # cd mysql
   # chown -R mysql .
   # chgrp -R mysql .
   # scripts/mysql_install_db --user=mysql
   # chown -R root .
   # chown -R mysql data/

5.启动数据库

   # mysqld_safe --user=mysql &

6.连接数据库

   # mysql --user=root mysql

7.创建数据库，创建数据库用户，赋予本地/远程登录权限

   > create database mysqldb;
   > INSERT INTO user (Host,User,Password) VALUES('localhost','dbuser',PASSWORD('password'));
   > INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','mysqldb','dbuser','Y','Y','Y','Y','Y','Y');
   > GRANT ALL PRIVILEGES ON *.* TO dbuser@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
   > GRANT ALL PRIVILEGES ON *.* TO dbuser@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;
   > FLUSH PRIVILEGES;

注:

数据库名 mysqldb

用户 dbuser

密码 password

8.数据导入
   #mysql --user=root mysqldb < schema.dump -p
   #mysql --user=root mysqldb < data.dump -p

9.登录服务

   # cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
   # ln -s /usr/local/mysql/support-files/mysql.server /etc/rc3.d/S99mysql
   # ln -s /usr/local/mysql/support-files/mysql.server /etc/rc0.d/K01mysql