发布时间 : 星期三 文章mysql在centos下免安装版更新完毕开始阅读2c5a47a2a32d7375a5178015
安装mysql,以下安装都在/usr/local目录下 rpm -qa | grep mysql
rpm -e “mysql的版本”--nodeps --force
tar zxvf mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz rm -rf mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz mv mysql-5.6.16-linux-glibc2.5-x86_64 mysql groupadd mysql
useradd -g mysql mysql cd mysql chown -R mysql . chgrp -R mysql .
ln /usr/lib64/libssl.so.10 /usr/lib64/libssl.so.6 ln /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.6
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --pid-file=/usr/local/mysql/data/mysql.pid --socket=/tmp/mysql.sock cd ..
chown -R root mysql . cd mysql
chown -R mysql data
bin/mysqld_safe --basedir=/usr/local/mysql --user=mysql & ctrl+c
cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysql vim /etc/my.cnf my.cnf文件类似如下: [client] port=3306
socket=/tmp/mysql.sock default-character-set=utf8
[mysqld] port=3306
socket=/tmp/mysql.sock character-set-server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES lower_case_table_names=1 继续?
cd /usr/local/mysql/bin ./mysql -u root
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY %use mysql;
update user set host = '%' where user = 'root'; flush privileges;
select host,user from user where user='root'; 至此,mysql安装完成.
查询数据表大小
select concat(round(sum(data_length/1024/1024),2),'MB') as
data_length_MB,concat(round(sum(index_length/1024/1024),2),'MB') as index_length_MB from tables where table_schema='gnet_ibd' and table_name = 'ibd_user_account';