MySQL安装
2023-02-23 15:34:10 5 举报
AI智能生成
MySQL安装
作者其他创作
大纲/内容
创建MySQL用户,并修改密码
上传包,解压
ln -fs/usr/local/mysql/bin/* /usr/bin
创建可执行文件的软链接
mkdir -p /var/lib/mysql/data /var/lib/mysql/logs
创建目录
touch /var/lib/mysql/logs/r68.err
创建错误日志文件
chown -R mysql.mysql /var/lib/mysql
修改权限
创建MySQL所需的相关目录和文件
mysqld --no-defaults --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/var/lib/mysql/data --innodb-data-file-path=ibdata1:2G:autoextend --innodb_undo_tablespaces=2 --lower-case-table-names=1
yum -y install numactl
初始化MySQL
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqldchkconfig --add mysqldchkconfig --levels 24 mysqld off
添加MySQL服务到系统服务中
vi /etc/my.cnf
创建配置文件
[client]user=rootpassword=123[mysqld]user=mysqlbasedir=/usr/local/mysqldatadir=/var/lib/mysql/datadefault_storage_engine=innodbserver_id=1111622port=3306skip_name_resolve=onlower_case_table_names=1log-bin=/var/lib/mysql/logs/r68-binlog_bin_index=/var/lib/mysql/logs/r68.indexlog_error=/var/lib/mysql/logs/r68.errinnodb_buffer_pool_size=1024M
将如下内容写入配置文件
创建并修改MySQL配置文件
service mysqld start
service mysqld status
mysql -u root -p
启动MySQL
安装
mkdir /var/log/mariadbtouch /var/log/mariadb/mariadb.logchown -R mysql:mysql /var/log/mariadb/ /usr/local/mysql/support-files/mysql.server start
进入vim /etc/my.cnf改一下路径socket=/tmp/mysql.sock
2. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
vi /etc/my.cnf #编辑文件,找到[mysqld],在下面添加一行skip-grant-tables[mysqld]skip-grant-tables:wq! #保存退出service mysqld restart #重启MySQL服务改密码ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';ALTER USER 'root'@'localhost' IDENTIFIED mysql_native_password BY '123456';(新版本)改完之后把配置文件中那一行再删了刷新一下 flush privileges;
3.忘记密码
报错解决
MySQL安装
收藏
收藏
0 条评论
回复 删除
下一页