linux安装mysql详细步骤

╰+哭是因爲堅強的太久メ 2023-09-24 08:47 89阅读 0赞

11、修改my.cnf文件

\#vi /etc/my.cnf

将下面内容复制替换当前的my.cnf文件中的内容

\[client\]

no-beep

socket=/software/mysql/mysql.sock

\# pipe

\# socket=0.0

port=3306

\[mysql\]

default-character-set=utf8

\[mysqld\]

basedir=/software/mysql

datadir=/data/mysql

port=3306

pid-file=/software/mysql/mysqld.pid

\#skip-grant-tables

skip-name-resolve

socket=/software/mysql/mysql.sock

character-set-server=utf8

default-storage-engine=INNODB

explicit\_defaults\_for\_timestamp=true

\# Server Id.

server-id=1

max\_connections=2000

query\_cache\_size=0

table\_open\_cache=2000

tmp\_table\_size=246M

thread\_cache\_size=300

\#限定用于每个数据库线程的栈大小。默认设置足以满足大多数应用

thread\_stack=192k

key\_buffer\_size=512M

read\_buffer\_size=4M

read\_rnd\_buffer\_size=32M

innodb\_data\_home\_dir=/data/mysql

innodb\_flush\_log\_at\_trx\_commit=0

innodb\_log\_buffer\_size=16M

innodb\_buffer\_pool\_size=256M

innodb\_log\_file\_size=128M

innodb\_thread\_concurrency=128

innodb\_autoextend\_increment=1000

innodb\_buffer\_pool\_instances=8

innodb\_concurrency\_tickets=5000

innodb\_old\_blocks\_time=1000

innodb\_open\_files=300

innodb\_stats\_on\_metadata=0

innodb\_file\_per\_table=1

innodb\_checksum\_algorithm=0

back\_log=80

flush\_time=0

join\_buffer\_size=128M

max\_allowed\_packet=1024M

max\_connect\_errors=2000

open\_files\_limit=4161

query\_cache\_type=0

sort\_buffer\_size=32M

table\_definition\_cache=1400

binlog\_row\_event\_max\_size=8K

sync\_master\_info=10000

sync\_relay\_log=10000

sync\_relay\_log\_info=10000

\#批量插入数据缓存大小，可以有效提高插入效率，默认为8M

bulk\_insert\_buffer\_size=64M

interactive\_timeout=120

wait\_timeout=120

log-bin-trust-function-creators=1

sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

\# include all files from the config directory

!includedir /etc/my.cnf.d

保存退出

12、启动mysql

\#/etc/init.d/mysqld start

新版本的安装包会报错，错误内容如下：

Starting MySQL.Logging to '/data/mysql/SZY.err'.

2018-07-02T10:09:03.779928Z mysqld\_safe The file /usr/local/mysql/bin/mysqld

does not exist or is not executable. Please cd to the mysql installation

directory and restart this script from there as follows:

https://www.cnblogs.com/shizhongyang/p/bin/mysqld\_safe&

See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information

ERROR! The server quit without updating PID file (/software/mysql/mysqld.pid).

因为新版本的mysql安全启动安装包只认/usr/local/mysql这个路径。

解决办法：

方法1、建立软连接

例 \#cd /usr/local/mysql

\#ln -s /sofware/mysql/bin/myslqd mysqld

方法2、修改mysqld\_safe文件(有强迫症的同学建议这种，我用的这种)

\# vim /software/mysql/bin/mysqld\_safe

将所有的/usr/local/mysql改为/software/mysql

保存退出。(可以将这个文件拷出来再修改然后替换)

13、登录mysql

\#/software/mysql/bin/mysql -u root –p

14、输入临时密码。临时密码就是第8条root@localhost:后面的内容

15、修改mysql的登录密码

>mysql set password=password('root');

>mysql grant all privileges on \*.\* to root@'%' identified by 'root';

>mysql flush privileges;

16、完成，此时mysql的登录名root 登录密码root

linux安装mysql详细步骤

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Linux之安装Linux详细步骤

相关 linux安装mysql详细步骤

相关 Mysql安装详细步骤

相关 Linux 系统安装 MySQL 教程（详细步骤）

相关 mysql 详细安装步骤

相关 Linux安装JDK详细步骤

相关 linux 安装mysql5.6 详细步骤

相关 linux安装jdk详细步骤

相关 linux下安装mysql5.6详细步骤

相关 linux上安装mysql详细步骤