mysqlÌí¼ÓÓû§
mysqlÌí¼ÓÓû§·½·¨
½¨Á¢Êý¾Ý¿âgamesp
create database gamesp;
Ìí
¼ÓÓû§
grant all on Êý¾Ý¿âÃû.* to Óû§
Ãû
@localhost identified by 'ÃÜÂë';
grant all on gamesp.* to
newuser@localhost
identified by
'password';
˵Ã÷£º
£¨1£©grant all ¸³ÓèËùÓеÄȨÏÞ
£¨2£©gamesp.* Êý¾Ý¿â gamesp ÖÐËùÓеıí
£¨3£©newuser Óû§Ãû
£¨4£©@localhost ÔÚ±¾µØµçÄÔÉ쵀 mysql server ·þÎñÆ÷
£¨5£©identfified by 'password' ÉèÖÃÃÜÂë
ɾ³ýÓû§
use mysql
mysql
>Delete
from user Where User="xxxxx" and Host="localhost";
mysql
>flush
privileges;
Ïà¹ØÎĵµ£º
InnoDB,ÆÕͨµÄmysql
dump±¸·ÝÏÂÀ´,mysql»Ö¸´ÆðÀ´ÂýµÃÒª
ËÀ.
ÓÚÊÇÍøÉÏÕÒÁ˺þÃ,²ÅÕÒµ½Õâô¸ö¹¤¾ß
.
http://launchpad.net/percona-xtrabackup/release-1.2/release-1.2/+download/xtrabackup-1.2.tar.gz
ÏȲâÊÔÏÂÔÙ˵.
¿ÉÒÔÕâô±¸·Ý:
MyISAM
񡜧
/usr/local/mysql/bin/mysqldump -uyejr -pyejr
--default-char ......
ÏÂÃæÎÒ¸ø´ó¼Ò½éÉܼ¸ÖÖÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨
·½·¨Ò»£º
ÔʼÃÜÂëÊÇ ckh
mysql -uroot -pckh
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
my ......
phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall to undefined function 'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã ......
1.²éÕÒµ±
mysql> show binary logs;
+—————-+———–+
| Log_name | File_size |
+—————-+———–+
| mysql-bin.000001 | 150462942 |
| mysql-bin.000002 | 125 |
| mysql-bin.000003 | 106 |
+&mdash ......