怡红快绿

Red Hat / Fedora Core RPM Packages:mysql-VERSION.i386.rpm (Required) mysql-server-VERSION.i386.rpm (Required) mysqlclient9-VERSION.i386.rpm (Shared object libraries) mysql-devel-VERSION.i386.rpm (C include files and libraries for software developers) php-m

利用Crontab为Linux（ubuntu）定时备份Mysql数据库利用系统Crontab来定时执行备份文件，按日期对备份结果进行保存，达到备份的目的。利用系统crontab来定时执行备份文件，按日期对备份结果进行保存，达到备份的目的。1、创建保存备份文件的路径/mysqldata （挂载到根目录下）#mkdir /mysqldata2、创建/usr/sbin/bakmysql文件#vi /usr/sbin/bakmysql输入rq=` date +%Y%m%d ` 网管联盟www.bitsCN.comt

<br />vi /etc/my.cnf <br />vi /etc/mysql/my.cnf<br />在[mysqld]下加入一行：<br />lower_case_table_names=1 <br />service mysql restart<br /> 

<br />mysql - u test - p1234 BugFree < D:/GreenAMP/BugFree.sql

grant usage on books.* to sally identified by 'magic123'; 创建一个没有任何权限的密码为magic123的用户sally,将usage换成all，就是赋予所有权限赋予权限：grant  select,insert,update,delete,index,alter,create,drop on books.* to sally; 上面两句，可以合成:grant select,insert,update,delete,index,alter,create

ps ax|grep mysql[client]port = 3306socket = /tmp/mysql.sock[mysqld]port = 3306bind-address = 127.0.0.1#bind-address = 10.181.54.211socket = /tmp/mysql.sock运行命令:  mysqld_safe &必要时用 ps ax|grep mysql  检测到mysql 进程后， kill 掉 再重启。

mysql -u root　　mysql> use mysql;　　mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';　　mysql> FLUSH PRIVILEGES;

show databases; The command mysql shows each database.

Show status