vi /etc/yum.repos.d/mysql-community.repo
# Enable to use MySQL 5.6 [mysql56-community] name=MySQL 5.6 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
/etc/init.d/mysqld start
D:/MySQL/MySQL Server 5.0/bin/mysqladmin -uroot flush-privileges password “newpassword”
D:/MySQL/MySQL Server 5.0/bin/mysqladmin -u root -p shutdown
将newpassword替换为你的新密码,第二个命令会让你重复输入一次新 密码。
6. 在cmd里net start mysql
mysql -h localhost -u root -p
启动 myql :mysqld_safe --user=mysql &
关闭mysql:mysqladmin -u root -p shutdown
mysql 导出
mysqldump -uroot -p123456 -hlocalhost --all-databases --lock-all-tables>a.sql
mysql导入
mysql>source d:\wcnc_db.sql
rpm command :
-Uvh:升级软件包--Update;
-qpl:列出RPM软件包内的文件信息[Query Package list];
-qpi:列出RPM软件包的描述信息[Query Package install package(s)];
-qf:查找指定文件属于哪个RPM软件包[Query File];
-Va:校验所有的RPM软件包,查找丢失的文件[View Lost];
-e:删除包
download file from office website : http://www.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.29-1.rhel5.x86_64.rpm/from/http://cdn.mysql.com/
run command to install: rpm -ivh MySQL-server-5.5.29-1.rhel5.x86_64.rpm
uninstall command: rpm -e MySQL-server-5.5.29-1.rhel5.x86_64
chown -R mysql:mysql /var/lib/mysql // grant permission to user(mysql)
cp /usr/share/mysql/my-small.cnf /etc/my.cnf
start mysql server command: mysqld_safe --user=mysql &
connect to databas: mysql -u root -p
报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
grant all privileges on *.* to 'root'@'%' identified by 'Zjw11763' with grant option;
mysql> insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));
//刷新系统权限表
mysql>flush privileges;
这样就创建了一个名为:phplamp 密码为:1234 的用户。
然后登录一下。
mysql>exit;
@>mysql -u phplamp -p
@>输入密码
mysql>登录成功
2.为用户授权。
//登录MYSQL(有ROOT权限)。我里我以ROOT身份登录.
@>mysql -u root -p
@>密码
//首先为用户创建一个数据库(phplampDB)
mysql>create database phplampDB;
//授权phplamp用户拥有phplamp数据库的所有权限。
>grant all privileges on phplampDB.* to phplamp@localhost identified by '1234';
//刷新系统权限表
mysql>flush privileges;
mysql>其它操作
/*
如果想指定部分权限给一用户,可以这样来写:
mysql>grant select,update on phplampDB.* to phplamp@localhost identified by '1234';
//刷新系统权限表。
mysql>flush privileges;
*/
3.删除用户。
@>mysql -u root -p
@>密码
mysql>DELETE FROM user WHERE User="phplamp" and Host="localhost";
mysql>flush privileges;
//删除用户的数据库
mysql>drop database phplampDB;
4.修改指定用户密码。
@>mysql -u root -p
@>密码
mysql>update mysql.user set password=password('新密码') where User="phplamp" and Host="localhost";
mysql>flush privileges;
面密码登陆 :mysqld_safe --user=mysql --skip-grant-tables --skip-networking &