iOS XMPP之mysql数据库的安装

alias mysql=/usr/local/mysql/bin/mysql

alias mysqladmin=/usr/local/mysql/bin/mysqladmin

mysqladmin -u root password 初始密码

mysqladmin -u root -p  password 最新密码

mysql -h 主机地址 -u 用户名 -p 用户密码

grant 操作权限 on 数据库.* to 用户名@登陆主机地址 identified by <span>'</span><span>密码</span><span>';</span>

grant all privileges on *.* to test1<span>@"</span><span>%</span><span>"</span> identified by <span>"</span><span>abc</span><span>"</span>;

grant <span>select</span>,insert,update,delete on *.* to test1<span>@"</span><span>%</span><span>"</span> identified by <span>"</span><span>abc</span><span>"</span>;

create database openfire;

grant all privileges on openfire.* to test2@localhost identified by <span>"</span><span>123</span><span>"</span>;

update mysql.user set password=password(<span>'</span><span>1234</span><span>'</span>) where User=<span>"</span><span>test1</span><span>"</span> and Host=<span>"</span><span>localhost</span><span>"</span>;

use mysql;

delete from user where User=<span>"</span><span>test7</span><span>"</span> and Host=<span>"</span><span>localhost</span><span>"</span>;

show databases;

use openfire;

show tables;

describe table1;

create database 库名;

<span>use 库名；

create table 表名 (字段设定列表);</span>

drop database 库名;

drop table 表名;

delete from 表名;

<span>select</span> * from 表名;

exit

/usr/local/mysql/share/mysql.server start

/usr/local/mysql/bin/mysqladmin -u root -p shutdown