step1:新建安装包上传目录
laojiang:~ # pwd
/root
laojiang:~ # mkdir mysql_setup
step2:sftp上传
sftp> cd mysql_setup/
sftp> pwd
/root/mysql_setup
sftp> lcd "E:\software\database\mysql\mysql5.6.11"
sftp> lls
MySQL-client-5.6.11-2.sles11.x86_64.rpm MySQL-server-5.6.11-2.sles11.x86_64.rpm
MySQL-shared-5.6.11-2.sles11.x86_64.rpm MySQL-shared-compat-5.6.11-2.sles11.x86_64.rpm
sftp> put *.*
Uploading MySQL-client-5.6.11-2.sles11.x86_64.rpm to /root/mysql_setup/MySQL-client-5.6.11-2.sles11.x86_64.rpm
100% 16444KB 8222KB/s 00:00:02
E:/software/database/mysql/mysql5.6.11/MySQL-client-5.6.11-2.sles11.x86_64.rpm: 16839318 bytes transferred in 2 seconds (8222 KB/s)
Uploading MySQL-server-5.6.11-2.sles11.x86_64.rpm to /root/mysql_setup/MySQL-server-5.6.11-2.sles11.x86_64.rpm
100% 50647KB 6330KB/s 00:00:08
E:/software/database/mysql/mysql5.6.11/MySQL-server-5.6.11-2.sles11.x86_64.rpm: 51862602 bytes transferred in 8 seconds (6330 KB/s)
Uploading MySQL-shared-5.6.11-2.sles11.x86_64.rpm to /root/mysql_setup/MySQL-shared-5.6.11-2.sles11.x86_64.rpm
100% 1676KB 1676KB/s 00:00:00
E:/software/database/mysql/mysql5.6.11/MySQL-shared-5.6.11-2.sles11.x86_64.rpm: 1716433 bytes transferred in 0 seconds (1676 KB/s)
Uploading MySQL-shared-compat-5.6.11-2.sles11.x86_64.rpm to /root/mysql_setup/MySQL-shared-compat-5.6.11-2.sles11.x86_64.rpm
100% 4266KB 4266KB/s 00:00:00
E:/software/database/mysql/mysql5.6.11/MySQL-shared-compat-5.6.11-2.sles11.x86_64.rpm: 4369365 bytes transferred in 0 seconds (4266 KB/s)
sftp>
step3:安装
laojiang:~ # cd mysql_setup/
laojiang:~/mysql_setup # ll
total 73140
-rw-r--r-- 1 root root 16839318 Feb 28 2014 MySQL-client-5.6.11-2.sles11.x86_64.rpm
-rw-r--r-- 1 root root 51862602 Feb 28 2014 MySQL-server-5.6.11-2.sles11.x86_64.rpm
-rw-r--r-- 1 root root 1716433 Feb 28 2014 MySQL-shared-5.6.11-2.sles11.x86_64.rpm
-rw-r--r-- 1 root root 4369365 Feb 28 2014 MySQL-shared-compat-5.6.11-2.sles11.x86_64.rpm
laojiang:~/mysql_setup #
laojiang:~/mysql_setup # rpm -ivh MySQL-*.rpm
Preparing... ########################################### [100%]
1:MySQL-shared-compat ########################################### [ 25%]
2:MySQL-client ########################################### [ 50%]
3:MySQL-server ########################################### [ 75%]
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
4:MySQL-shared ########################################### [100%]
laojiang:~/mysql_setup #
然后可以查看下面5个目录有内容
ll /usr/bin/mysql*
ll /usr/sbin/mysql*
ll /var/lib/mysql/mysql*
ll /usr/share/info/mysql*
ll /usr/share/mysql/mysql*
下面4个目录无内容
ll /usr/share/man/mysql*
ll /usr/include/mysql/mysql*
ll /usr/lib/mysql/mysql*
ll /usr/share/sql-bench/mysql*
MySQL Installation Layout for Linux RPM Packages
Directory Contents of Directory
/usr/bin Client programs and scripts
/usr/sbin The mysqld server
/var/lib/mysql Log files, databases
/usr/share/info Manual in Info format
/usr/share/man Unix manual pages
/usr/include/mysql Include (header) files
/usr/lib/mysql Libraries
/usr/share/mysql Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation
/usr/share/sql-bench Benchmarks
step4:服务控制
service mysql start
service mysql status
service mysql stop
step5:修改root用户密码
laojiang:~ # mysqld_safe --skip-grant-tables &
laojiang:~ # mysql -uroot -p
Enter password: 【直接回车即可,无需输入密码】
mysql> use mysql;
mysql> update user set password=PASSWORD("root") where user="root";
mysql> flush privileges;
mysql> quit;
laojiang:~ # service mysql restart
laojiang:~ # mysql -uroot -proot
mysql> show variables like '%char%';
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> set password=password('root');
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29911917/viewspace-1280879/
,如需转载,请注明出处,否则将追究法律责任。