ÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootµÄÃÜÂë
ÏÂÃæÎÒ¸ø´ó¼Ò½éÉܼ¸ÖÖÔÚ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.
mysql> use mysql
Database changed
mysql> update user set password=password('newpass') where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
·½·¨¶þ£º
ÔʼÃÜÂëÊÇ newpass , ÐÂÃÜÂëÊÇ mysql
mysqladmin -uroot -pnewpass password mysql
·½·¨Èý
ÔʼÃÜÂëÊÇ mysql , ÐÂÃÜÂëÊÇ ckh
mysql -uroot -pmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> set password for root@'localhost'=password('ckh');
Query OK, 0 rows affected (0.00 sec)
mysql>
ÏÂÃæÁгöһЩ³£ÓõÄmysqlÊý¾Ý¿â¹ÜÀíÃüÁ
°²×° ÀûÓÃRPM°ü°²×°Mysql ¡¡
ÉèÖÃTCP 3306¶Ë¿ÚµÄiptables ¡¡
¡¡
rootÃÜÂë¹ÜÀí ÉèÖÃrootÓû§µÄÃÜÂë mysqladmin -uroot password 'password'
ÐÞ¸ÄrootÓû§µÄÃÜÂë mysqladmin -uroot -p password 'password'
¡¡
Êý¾Ý¿â£¬±í¹ÜÀí ½øÈëmysql mysql -h hostname -uroot -p
´´½¨Êý¾Ý¿â mysql> create database location
µ¼ÈëÊý¾Ý½á¹¹ mysql -uroot -p
Ïà¹ØÎĵµ£º
ÓÃmysql_query£¬mysql_fetch_array()ºóÓ¦¸ÃÒª
free_result().function count_admin($where = '')
{
if($where) $where = " WHERE $where";
$result = $this->db->get_one("SELECT count(*) as num from $this->table_admin_role $where");
return $result['num'];
} ......
1005£ºMYSQL´´½¨±íʧ°Ü
¡¡¡¡
¡¡¡¡1006£ºMYSQL´´½¨Êý¾Ý¿âʧ°Ü
¡¡¡¡
¡¡¡¡1007£ºMYSQLÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
¡¡¡¡
¡¡¡¡1008£ºMYSQLÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
¡¡¡¡
¡¡¡¡1009£ºMYSQL²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
¡¡¡¡
¡¡¡¡1010£ºMYSQL²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
¡¡¡¡
&nbs ......
select `a`.`id` AS `id`,`a`.`UserName` AS `UserName`,
(case when (`a`.`sRegDate` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`sRegDate`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `sRegDate`,(case when (`a`.`feeendtime` = _utf8'1990-01-01 00:00:00.0') then _ut ......
mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ
//Ö÷¼ü549830479
alter table tabelname add new_fiel ......
mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯
MYSQLµÄÓÅ»¯ÊǷdz£ÖØÒªµÄ¡£ÆäËû×î³£ÓÃÒ²×îÐèÒªÓÅ»¯µÄ¾ÍÊÇlimit¡£mysqlµÄlimit¸ø·ÖÒ³´øÀ´Á˼«´óµÄ·½±ã£¬µ«Êý¾ÝÁ¿Ò»´óµÄʱºò£¬limitµÄÐÔÄܾͼ±¾çϽµ¡£
ͬÑùÊÇÈ¡10ÌõÊý¾Ý
select * from yanxue8_visit limit 10000,10 ºÍ
select * from yanxue8_visit limit 0,10
¾Í²»ÊÇÒ»¸öÊýÁ¿¼¶±ðµ ......