Linux学习心得
Centos7系统MySQL安装:1. wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm2. rpm -ivh mysql-community-release-el7-5.noarch.rpm3. yum install mysql-community-server4. MySQL服务重启:...
·
Centos7系统MySQL安装:
- wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
- rpm -ivh mysql-community-release-el7-5.noarch.rpm
- yum install mysql-community-server
- MySQL服务重启:service mysqld restart
- 设置root用户名密码:
mysql -u root
mysql> set password for ‘root’@‘localhost’ = password(‘mypasswd’);
mysql> exit
6.MySQL版本查询:mysql --version
7.修改字符集:
查看当前 MySQL 字符集:mysql> show variables like ‘character%’;
修改成utf8: vim /etc/my.cnf,添加如下配置:
[mysqld]
character_set_server = utf8
[mysql]
default-character-set = utf8
重启MySQL:service mysqld restart
重新查询:mysql> show variables like ‘character%’;
8.用navicat远程连接Linux系统的MySQL:
注意要关闭防火墙(centos7命令:systemctl stop firewalld.service
mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘lwl980429’ WITH GRANT OPTION;
mysql> flush privileges;
格式:grant 权限 on 数据库.* to 用户名@登录主机 identified by “密码”;
mysql>grant all privileges on . to root@’%’ identified by ‘root’;
mysql>flush privileges;
tar -zxvf命令详解:
x : 从 tar 包中把文件提取出来
z : 表示 tar 包是被 gzip 压缩过的,所以解压时需要用 gunzip 解压
v : 显示详细信息
f xxx.tar.gz : 指定被处理的文件是 xxx.tar.gz
Ubuntu设置允许root用户登录:
sudo passwd
vim /etc/ssh/sshd_config
找到 PermitRootLogin 这项 将其改为 yes
service ssh restart
更多推荐
已为社区贡献1条内容
所有评论(0)