文档.txt
[root@localhost ~]# systemctl start mysql.service
Failed to start mysql.service: Unit mysql.service not found.
MariaDB代替了mysql数据库,MariaDB数据库管理系统是MySQL的一个分支,
因此用上述命令启动不起来,正确的方法如下
# yum install mariadb-server -y //如果已安装可以省略
# systemctl start mariadb.service //启动服务
# systemctl enable mariadb.service //开机启动服务
# mysql -u root -p //登录mysql
Mysql客户端连接不上
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
Linux Mysql客户端连接不上
[root@ ~]# mysql -u root -p
Enter password:
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xiaobaiyang' WITH GRANT OPTION;
MariaDB [(none)]> commit;
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit;
Bye
1.终端启动 MySQL:/etc/init.d/mysql start
2.登录 MySQL:mysql -uroot -p (用 root 账户登录),然后输入密码
3.查看所有的数据库名字:show databases;
4.选择一个数据库操作: use database_name;
5.查看当前数据库下所有的表名:show tables;
6.创建一个数据库:create database database_name;
7.删除一个数据库:drop database database_name;
8.创建一个表: create table mytest( uid bigint(20) not null primary key, uname varchar(20) not null);
9.删除一个表: drop table mytest;
10.SQL 插入语句:insert into table_name(col1,col2) values(value1,value2);
11.SQL 更新语句:update table_name set col1='value1',col2='value2' where where_definition;
12.SQL 查询语句:select * from table_name where.......
13.SQL 删除语句:delete from table_name where...
14.增加表结构的字段:alert table table_name add column field1 date ,add column field2 time...
15.删除表结构的字段:alert table table_name drop field1;
16.查看表的结构:show columns from table_name;
17.limit 的使用:select * from table_name limit 3; //每页只显示 3 行
select * from table_name limit 3,4; //从查询结果的第三个开始,显示四项结果。 此处可很好的用来作分页处理。
18.对查询结果进行排序: select * from table_name order by field1,orderby field2;多重排序
19.退出 MySQL:exit;
20.删除表中所有数据: truncate table 数据表名称 (不可恢复)
在用Navicat for MySQL远程连接mysql的时候,出现了
Lost connection to MySQL server at ‘reading initial communication packet', system error: 0
第一步:找到:my.cnf文件
[root@ ~]# find / -name my.cnf
/etc/my.cnf
第二步:在mysqld下添加skip-name-resolve
[root@ etc]# vim /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-name-resolve #新增
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
第三步:保存
Mysql客户端连接不上,提示如下:
error No.2013
lost connection to mysql server at 'reading intial cimmunication packet',system erroe:2
原因:阿里云服务器没有添加对应的端口