mysql-5.6.30-linux-glibc2.5-x86_64安装


centos7内部集成了mariadb，而安装mysql的话会和mariadb的文件冲突，所以需要先卸载掉mariadb。

一、卸载mariadb
#列出所有被安装的rpm package
rpm -qa | grep mariadb


#卸载
rpm -e mariadb-libs-5.5.37-1.el7_0.x86_64
错误：依赖检测失败。
#强制卸载，因为没有--nodeps
rpm -e --nodeps mariadb-libs-5.5.37-1.el7_0.x86_64


二、安装mysql
解压缩： tar -zxvf mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz -C /usr/zhjc/mysql

2、创建mysql组和mysql用户

3、修改目录权限

4、安装
# ./scripts/mysql_install_db --user=mysql --basedir=/usr/zhjc
/mysql/mysql-5.6.30-linux-glibc2.5-x86_64 --datadir=/usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/data
出错了：
解决方法 ：安装autoconf库
命令：yum -y install autoconf //此包安装时会安装Data:Dumper模块
在次执行安装，安装成功，安装log：
[root@VM_76_159_centos mysql-5.6.30-linux-glibc2.5-x86_64]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/zhjc
/mysql/mysql-5.6.30-linux-glibc2.5-x86_64 --datadir=/usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/dataInstalling MySQL system tables...2018-06-14 10:35:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. P
lease use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-06-14 10:35:46 0 [Note] /usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/bin/mysqld (mysqld 5.6.30) starting as
process 12201 ...2018-06-14 10:35:46 12201 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-06-14 10:35:46 12201 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-14 10:35:46 12201 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-14 10:35:46 12201 [Note] InnoDB: Memory barrier is not used
2018-06-14 10:35:46 12201 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-06-14 10:35:46 12201 [Note] InnoDB: Using Linux native AIO
2018-06-14 10:35:46 12201 [Note] InnoDB: Using CPU crc32 instructions
2018-06-14 10:35:46 12201 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-14 10:35:46 12201 [Note] InnoDB: Completed initialization of buffer pool
2018-06-14 10:35:46 12201 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be cr
eated!2018-06-14 10:35:46 12201 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2018-06-14 10:35:46 12201 [Note] InnoDB: Database physically writes the file full: wait...
2018-06-14 10:35:47 12201 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-06-14 10:35:48 12201 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-06-14 10:35:49 12201 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-06-14 10:35:49 12201 [Warning] InnoDB: New log files created, LSN=45781
2018-06-14 10:35:49 12201 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-06-14 10:35:49 12201 [Note] InnoDB: Doublewrite buffer created
2018-06-14 10:35:49 12201 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-14 10:35:49 12201 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-06-14 10:35:49 12201 [Note] InnoDB: Foreign key constraint system tables created
2018-06-14 10:35:49 12201 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-06-14 10:35:49 12201 [Note] InnoDB: Tablespace and datafile system tables created.
2018-06-14 10:35:49 12201 [Note] InnoDB: Waiting for purge to start
2018-06-14 10:35:49 12201 [Note] InnoDB: 5.6.30 started; log sequence number 0
2018-06-14 10:35:50 12201 [Note] Binlog end
2018-06-14 10:35:50 12201 [Note] InnoDB: FTS optimize thread exiting.
2018-06-14 10:35:50 12201 [Note] InnoDB: Starting shutdown...
2018-06-14 10:35:52 12201 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK

Filling help tables...2018-06-14 10:35:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use -
-explicit_defaults_for_timestamp server option (see documentation for more details).2018-06-14 10:35:52 0 [Note] /usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/bin/mysqld (mysqld 5.6.30) starting as
process 12224 ...2018-06-14 10:35:52 12224 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-06-14 10:35:52 12224 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-14 10:35:52 12224 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-14 10:35:52 12224 [Note] InnoDB: Memory barrier is not used
2018-06-14 10:35:52 12224 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-06-14 10:35:52 12224 [Note] InnoDB: Using Linux native AIO
2018-06-14 10:35:52 12224 [Note] InnoDB: Using CPU crc32 instructions
2018-06-14 10:35:52 12224 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-14 10:35:52 12224 [Note] InnoDB: Completed initialization of buffer pool
2018-06-14 10:35:52 12224 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-14 10:35:52 12224 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-14 10:35:52 12224 [Note] InnoDB: Waiting for purge to start
2018-06-14 10:35:52 12224 [Note] InnoDB: 5.6.30 started; log sequence number 1625977
2018-06-14 10:35:52 12224 [Note] Binlog end
2018-06-14 10:35:52 12224 [Note] InnoDB: FTS optimize thread exiting.
2018-06-14 10:35:52 12224 [Note] InnoDB: Starting shutdown...
2018-06-14 10:35:54 12224 [Note] InnoDB: Shutdown completed; log sequence number 1625987
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

  /usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/bin/mysqladmin -u root password 'new-password'
  /usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/bin/mysqladmin -u root -h VM_76_159_centos password 'new-password'

Alternatively you can run:

  /usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

  cd . ; /usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

  cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings


5、修改数据库默认编码
在 my.cnf 和 support-files/my-default.cnf添加配置：
character_set_server=utf8


6、配置系统参数

[root@VM_76_159_centos support-files]# cp my-default.cnf /etc/my.cnf
[root@VM_76_159_centos support-files]# cp mysql.server /etc/rc.d/init.d/mysql
配置环境变量：
[root@VM_76_159_centos support-files]# vi /etc/profile
添加：
export MYSQL_HOME="/usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64"
export PATH="$PATH:$MYSQL_HOME/bin"

修改mysql文件：
[root@VM_76_159_centos support-files]# vim /etc/init.d/mysql
添加：
basedir=/usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64
datadir=/usr/zhjc/mysql/mysql-5.6.30-linux-glibc2.5-x86_64/data

配置开机启动：
添加mysql：
[root@VM_76_159_centos support-files]# chkconfig --add mysql
设置开机启动：
[root@VM_76_159_centos support-files]# chkconfig mysql on

启动mysql：
service mysql start

7、登录mysql及改密码与配置远程访问
进入bin目录，设置root密码：
[root@VM_76_159_centos mysql-5.6.30-linux-glibc2.5-x86_64]# cd bin/
[root@VM_76_159_centos bin]# ./mysqladmin -u root password 'root-password'

设置完登录：
[root@VM_76_159_centos bin]# mysql -uroot -p
-bash: mysql: command not found
提示找不到mysql指令，执行source /etc/profile，使刚刚配置的东西生效，在登录：


配置权限;
允许root用户远程访问：
格式：grant 权限 on 数据库名.表名 用户@登录主机 identified by “用户密码”

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
说明;
ALL PRIVILEGES表示赋给远程登录用户的权限，ALL PRIVILEGES表示所有的权限，你也可以单独或组合赋select,update,insert,delete权限； . ：第一个 表示要赋权的数据库名， 当然表示全部数据库了，第二个 表示数据库下的表名，同理， 表示全部表。root表示要赋权的用户；%表示远程登录的IP（你用来登录的ip），如果要限制登录IP的话，这里就添你允许登录的IP，比如192.18.1.99等，%表示不限制IP，000000是用户远程登录的密码

刷新权限，立即生效。
FLUSH PRIVILEGES;


# linux # linux
Logo
Linux

更多推荐

网卡速率和双工模式的配置

http://linux.chinaitlab.com/system/792187.html1、mii-tool 配置网络设备协商方式的工具；    1.1 mii-tool 介绍；    mii-tool - view, manipulate media-independent interface status （mii-tool 是查看，管理介质的网络接口的状态）

avatar Linux

Linux虚拟文件系统之文件系统卸载（sys_umount())

Linux中卸载文件系统由umount系统调用实现，入口函数为sys_umount()。较于文件系统的安装较为简单，下面是具体的实现。1. /*sys_umont系统调用*/2. SYSCALL_DEFINE2(umount, char __user *, name, int, flags)3. {4.struct path path;

avatar Linux

Linux系统下超级终端Minicom的使用方法（例如：连接交换机，路由器等）转http://baike.baidu.com/view/2911642.htm?fr=ala0_1

<br />　　Linux系统下超级终端Minicom的使用方法 <br />　　Linux下的Minicom的功能与下的超级终端功能相似，适于在通过超级终端对设备的管理以及对嵌入操作系统的升级，现写出Minicom的使用手册： <br />　　1． 启动minicom <br />　　以root权限登录系统 <br />　　使用命令 <br />　　minicom –s 则minicom启动，屏

avatar Linux