Mysql 5.7.17安装后登录mysql的教程
16lz
2022-01-03
mysql-5.7.17的安装在文章下面有介绍,大家可以参考下。下面先给大家介绍下Mysql 5.7.17安装后登录mysql的教程,一起看看吧。
在运行 ./bin/mysqld –initialize 初始化数据库时,会生成随机密码,示例:
[Note] A temporary password is generated for root@localhost: Wtng#?e&S5,-
$ /usr/local/mysql/bin/mysql -uroot -p'Wtng#?e&S5,-'
mysql> set password = password('mypassword');
$ vi /etc/my.cnf [mysqld]配置区域添加: skip-grant-tables$ service mysqld restart
$ /usr/local/mysql/bin/mysql -uroot mysql> update user set authentication_string=password('mypassword') where user='root';mysql> quit
源码安装mysql-5.7.17(centos-6.8-minimal)的方法
官方文档
http://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
准备工作
1.安装wget、gcc、gcc-c++、bison、ncurses、ncurses-devel
$ yum install –y wget gcc gcc-c++ bison ncurses ncurses-devel
$ cd /usr/local/src/$ wget https://cmake.org/files/v3.7/cmake-3.7.1.tar.gz$ tar zxvf cmake-3.7.1.tar.gz$ cd cmake-3.7.1$ ./bootstrap && gmake && gmake install
$ wget https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz$ tar zxf boost_1_59_0.tar.gz$ mv boost_1_59_0 /usr/local/
$ cd /usr/local/src/$ wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz$ tar zxvf mysql-5.7.17.tar.gz
1.创建用户和组mysql:mysql
$ groupadd mysql$ useradd -r -g mysql -s /sbin/nologin mysql
$ cd /usr/local/src/mysql-5.7.17$ mkdir build$ cd build$ cmake .. \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DSYSCONFDIR=/etc \-DMYSQL_DATADIR=/data/mysql \-DMYSQL_USER=mysql \-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DENABLED_LOCAL_INFILE=1 \-DWITH_BOOST=/usr/local/boost_1_59_0$ make && make install
$ cd /usr/local/mysql$ chown -R mysql:mysql .$ mkdir -p /data/mysql$ chown -R mysql.mysql /data/mysql$ ./bin/mysqld --initialize \--user=mysql \--basedir=/usr/local/mysql \--datadir=/data/mysql$ ./bin/mysql_ssl_rsa_setup --datadir=/data/mysql
4.配置文件
$ cp support-files/my-default.cnf /etc/my.cnf$ vim !$
basedir = /usr/local/mysqldatadir = /data/mysqlport = 3306socket = /tmp/mysql.sock
$ cp support-files/mysql.server /etc/init.d/mysqld$ vim !$
basedir = /usr/local/mysql datadir = /data/mysql
6.启动mysqld服务
/etc/init.d/mysqld start
$ chkconfig --add mysqld$ chkconfig mysqld on$ service mysqld start
更多相关文章
- MySQL系列多表连接查询92及99语法示例详解教程
- Linux下MYSQL 5.7 找回root密码的问题(亲测可用)
- MySQL 什么时候使用INNER JOIN 或 LEFT JOIN
- Pycharm安装PyQt5的详细教程
- 【阿里云镜像】使用阿里巴巴DNS镜像源——DNS配置教程
- android用户界面之按钮(Button)教程实例汇
- 【Android(安卓)开发教程】Toast通知
- Android简易实战教程--第三十九话《Chronometer实现倒计时》
- android加密解密完美教程