ITPub博客

首页 > 数据库 > MySQL > mysql安装办法

mysql安装办法

原创 MySQL 作者:laojiangjiji 时间:2014-09-25 18:25:45 0 删除 编辑


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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-09-23

  • 博文量
    35
  • 访问量
    48739