首页 > 数据库 > MySQL > IBM /AIX 环境快速部署MySQL
[gpp@aix61:/home/gpp]$ uname -pua
AIX aix 1 6 00F9FCE54C00 powerpc IBM,0284EFE5V
-- 获取CPU 位数

-- 获取操作系统详细

利用shell 脚本,在AIX环境中快速部署MySQL,以提供开发人员进行测试。
其中, gz552sh 为shell 脚本可执行文件, 详细内容如下:
[gpp@aix:/home/ggp]$cat
gz552sh
cp -p /home/gpp/gz552 /home/gpp/gz552.old
cd /home/gpp
mv /home/gpp/gz552 /home/gpp/gz552.gz
gunzip gz552
cd /usr/local
tar xvf /home/gpp/gz552
cd /usr/local
mv mysql-5.5.2-m2-aix5.3-powerpc-64bit mysql
chown -R gpp:oinstall /usr/localmysql
cd /home/gpp
/usr/local/mysql/scripts/mysql_install_db --user=gpp --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
cd /usr/local/mysql;/usr/local/mysql/bin/mysqld_safe --user=gpp &
sleep 5
/usr/local/mysql/bin/mysqladmin -u root password 'Oracle_4U'
/usr/local/mysql/bin/mysql -u root -pOracle_4U </home/gpp/cru
echo Shutdown MySQL ...
sleep $1
/usr/local/mysql/bin/mysqladmin -u root -pOracle_4U shutdown
echo Clean all file for the lab
cd /usr/local
sleep $1
rm -rf /usr/local/mysql
rm -rf /home/gpp/gz552
# restore .gz old file
mv /home/gpp/gz552.old /home/gpp/gz552
其中 cru 为MySQL创建测试用户的脚本,内容如下:
[gpp@aix:/home/ggp]$cat /home/gpp/cru
-- drop user cs@'%';
create user cs@'%' identified by 'new_password';
grant all on *.* to cs@'%';
flush privileges;
exit;
cd /home/gpp/gz552
tar cvf gz552.tar /usr/localmysql
mv gz552.tar gz552
[gpp@aix:/home/ggp]$ /usr/local/bin/mysql -uroot -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.2-m2 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
select version();
+-------------------------------------------+
| version() |
+-------------------------------------------+
| 5.5.2-m2 |
+-------------------------------------------+
1 row in set (0.00 sec)
mysql>
原始介质下载:
downloads.mysql.com/archives/community/

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70024552/viewspace-2927145/ ,如需转载,请注明出处,否则将追究法律责任。