1.当前目录:修改属主属组
cd /usr/local/mysql
chown -R mysql.mysql .
2.初始化数据库:mysql/bin/mysqld
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/
#拿到随机密码:
#[Note] A temporary password is generated for root@localhost: ?hK7d1?rWXr6
3.修改配置文件:
vim /etc/my.cnf
#将文件中所有内容注释掉在添加如下内容
[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8
[mysqld]
port = 3306
user = mysql
basedir = /usr/local/mysql #指定安装目录
datadir = /usr/local/mysql/data #指定数据存放目录
socket = /tmp/mysql.sock
character_set_server = utf8
##参数详解:
[client]
port = 3306 # 默认连接端口
socket = /tmp/mysql.sock # 用于本地连接的socket套接字
default-character-set = utf8 # 编码
[mysqld]
port = 3306 # 服务端口号,默认3306
user = mysql # mysql启动用户
basedir = /usr/local/mysql # mysql安装根目录
datadir = /usr/local/mysql/data # mysql数据文件所在位置
socket = /tmp/mysql.sock # 为MySQL客户端程序和服务器之间的本地通讯指定一个套接字文件
character_set_server = utf8 # 数据库默认字符集,
##
4.启动Mysql,并修改密码:
./bin/mysqld_safe --user=mysql &
#改密码为:1
/usr/local/mysql/bin/mysqladmin -u root -p'?hK7d1?rWXr6' password '1'
4.修改环境变量,并启动服务:4种方式
1.复制mysql服务,把启动脚本放到开机初始化目录
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
#启动MySQL服务
service mysqld start
service mysqld status
service mysqld stop
2.制作别名:
aliase mysql_server="/usr/local/mysql/support-files/mysql.server"
aliase mysql="/usr/local/mysql/bin/mysql"
3.与 usr/bin/ 做软连接
ln -s /usr/local/mysql/bin/mysql mysql
4.加入 PATH 环境变量
vim /etc/profile
#输入:
PATH=$PATH:/usr/local/mysql/bin
#执行一下:
source /etc/profile
5.登录mysql
mysql -u root -p'密码'
1、bin目录
用于放置一些可执行文件,如mysql、mysqld、mysqlbinlog等。
2、include目录
用于放置一些头文件,如:mysql.h、mysql_ername.h等。
3、lib目录
用于放置一系列库文件。
4、share目录
用于存放字符集、语言等信息。
标签:bin,--,安装,源码,mysqld,usr,mysql,local From: https://blog.csdn.net/qq_43606536/article/details/140476398