Linux(CentOS)下,安装MySQL
来源:互联网 发布:linux mv命令 复制 编辑:程序博客网 时间:2024/05/17 08:58
# yum install -y mysql-devel
# yum install -y mysql-server
# yum install -y mysql
# chgrp -R mysql /var/lib/mysql
# chmod -R 770 /var/lib/mysql
# service mysqld start
MySQL Daemon failed to start.
如果启动失败,可以用下面的命令,查看失败原因:
# less /var/log/mysqld.log
发现如下的错误提示:
InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB)
than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
修改配置文件中的值(640/64=10M)并查看修改结果:
# vi /etc/my.cnf
innodb_data_file_path = ibdata1:10M:autoextend
# du -sm /var/lib/mysql/ibdata1
10 /var/lib/mysql/ibdata1
设置开机自启动,并查看设置结果:
# chkconfig mysqld on
# chkconfig mysqld --list
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
创建根用户密码,并登陆测试:
# mysqladmin -u root password 123456 #//然后输入新密码,并确认一次
# mysql -u root -p
忘记密码时,可用如下方法重置:
# service mysqld stop
# mysqld_safe --user=root --skip-grant-tables --skip-networking &
# mysql -u root
mysql> use mysql;
mysql> update user set password=password("new_password") where user="root";
mysql> flush privileges;
远程登陆的授权:
# yum install -y mysql-server
# yum install -y mysql
# chgrp -R mysql /var/lib/mysql
# chmod -R 770 /var/lib/mysql
# service mysqld start
MySQL Daemon failed to start.
如果启动失败,可以用下面的命令,查看失败原因:
# less /var/log/mysqld.log
发现如下的错误提示:
InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB)
than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
修改配置文件中的值(640/64=10M)并查看修改结果:
# vi /etc/my.cnf
innodb_data_file_path = ibdata1:10M:autoextend
# du -sm /var/lib/mysql/ibdata1
10 /var/lib/mysql/ibdata1
设置开机自启动,并查看设置结果:
# chkconfig mysqld on
# chkconfig mysqld --list
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
创建根用户密码,并登陆测试:
# mysqladmin -u root password 123456 #//然后输入新密码,并确认一次
# mysql -u root -p
忘记密码时,可用如下方法重置:
# service mysqld stop
# mysqld_safe --user=root --skip-grant-tables --skip-networking &
# mysql -u root
mysql> use mysql;
mysql> update user set password=password("new_password") where user="root";
mysql> flush privileges;
远程登陆的授权:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
远程登陆的授权成功后,可以用如下命令查看,如果有host为%的项,说明是OK的。
mysql> select host,user,password from user;+-----------+------+-------------------------------------------+| host | user | password |+-----------+------+-------------------------------------------+| localhost | root | *6C1C7AE8E372FE12E3DE2E22FE6C04CF8F6737DA || 127.0.0.1 | root | *6C1C7AE8E372FE12E3DE2E22FE6C04CF8F6737DA || ::1 | root | *6C1C7AE8E372FE12E3DE2E22FE6C04CF8F6737DA || localhost | | || % | root | *6C1C7AE8E372FE12E3DE2E22FE6C04CF8F6737DA |+-----------+------+-------------------------------------------+5 rows in set (0.00 sec)
0 0
- Centos下安装MySQL全过程(linux下安装MySQL)
- Linux(CentOS)下,安装MySQL
- CentOS Linux下安装 mysql
- linux centOS 下安装mysql
- linux下CentOS安装MySQL
- Linux-centos下安装mysql
- Linux(CentOs) 下安装 Mysql
- linux(centos)下mysql安装搭建配置
- 44、Linux初步(CentOS 7下安装MySql)
- Linux(centos)下mysql的安装以及使用
- linux下安装mysql(CentOS系统为例)
- centos linux下卸载并安装MYSQL
- centOS Linux下用yum 安装mysql
- Linux CentOS下安装、配置mysql数据库
- centOS Linux下用yum安装mysql
- Linux(centos)下mysql编译安装教程
- Linux(CentOS)环境下安装MySQL
- linux(CentOS 7) 下安装MySQL
- 一个重启Tomcat的简单shell命令
- 文本框,智能提示信息
- WinForm中MenuStrip控件
- Trace Neutron code - neutron-server
- 全局偏移量表和过程链接表
- Linux(CentOS)下,安装MySQL
- PCA与特征选取
- BEGINNING SHAREPOINT® 2013 DEVELOPMENT 第3章节--SharePoint 2013 开发人员工具
- opencv中感兴趣区域以及mask的使用
- 06 基本包装类型
- 毕业后--反思生活
- wcf 值 endpoint
- 最近学习openmax总结
- POJ 2299 Ultra-QuickSort(归排并序)