windows:
启动
方式1.services.msc 打开windows的服务管理器,启动mysql服务器
方式2.cmd-->net start mysql
连接
cmd-->mysql -h localhost -uroot -p
linux
安装服务端
a.tar -xvf mysql-XXXX.tar 解压
b.rpm -ivh mysql-server-xxx.rpm 安装
c.services mysqld start
查看:rpm -qa|grep -i mysql
卸载:rpm -ev mysql-xxx
安装客户端
rpm -ivh mysql-client-xxx.rpm 安装
mysql -hlocalhost -uroot 登录数据库
/usr/bin/mysqladmin -uroot password'123456' 更改root密码
grant all privileges on *.* to jason@localhost identified by '123456' with grant option;创建新用户
修改字符集
show variables like 'character%';
set character_set_server=utf8;