MySQL AdministratorÎÞ·¨Á¬½Ó·þÎñÆ÷µÄ½â¾ö·½·¨
ĬÈÏÇé¿öÏÂLinuxÄÚµÄmysqlÊý¾Ý¿âmysql.user±íÄÚµÄÓû§È¨ÏÞÖ»ÊǶÔlocalhost¼´±¾»ú²ÅÄܵǽ¡£ËùÒÔÐèÒª¸ü¸ÄȨÏÞ£¬·ñÔòÎÞ·¨Ê¹ÓÃMysql AdministratorÁ¬½Ó·þÎñÆ÷£¬»á·¢ÉúÈçÏÂËùʾµÄ´íÎó£º
MySQL Administrator 1.1.9ÅäÖÃ,Á¬½ÓmysqlÊý¾Ý¿â
Could not connect to the specified instance
MySQL Error Number 1130
Host '192.168.1.51' is not allowed to connect to this MySQL server
if you want to check the net connection , please click the ping buttion
½â¾öµÄ·½·¨£¬Ê×ÏÈ°´ÕÕÈçϵķ½Ê½È·ÈÏ·þÎñÆ÷ÉϵÄuser±íÖеÄȨÏÞÉèÖã¬Ö´ÐÐÃüÁ
root#mysql -h localhost-u mysql -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.20a-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql; (´ËDB´æ·ÅMySQLµÄ¸÷ÖÖÅäÖÃÐÅÏ¢)
Database changed
mysql> select host,user from user; (²é¿´Óû§µÄȨÏÞÇé¿ö)
+-------------+-------+
| host | user |
+-------------+-------+
| localhost | |
| localhost | root |
| localhost | |
| localhost | mysql |
+-------------+-------+
6 rows in set (0.02 sec)
ÓÉ´Ë¿ÉÒÔ¿´³ö£¬Ä¿Ç°Ö»ÄÜÒÔlocalhostµÄÖ÷»ú·½Ê½·ÃÎÊ¡£½â¾ö·½·¨¾ÍÊÇÐÞ¸ÄȨÏÞ£¬Ö´ÐÐÈçÏÂÃüÁ
mysql> Grant all privileges on *.* to 'root'@'%' identified by ‘password’ with grant option;
ÏàÓ¦²ÎÊýµÄ½âÊÍÈçÏ£º
all privileges ÊÇÖ
Ïà¹ØÎĵµ£º
ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕͨÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔغõēapache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃ棺
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃ棬µã“Next”¼ÌÐø
È·È ......
PHPÊÖ²áÉÏÌṩÁËÒÔÏÂһЩÖ÷ÒªµÄmysqlÊý¾Ý¿âµÄÖ§³Öº¯Êý£º
mysql_affected_rows -- È¡µÃÇ°Ò»´Î MySQL ²Ù×÷ËùÓ°ÏìµÄ¼Ç¼ÐÐÊý
mysql_change_user -- ¸Ä±ä»î¶¯Á¬½ÓÖеǼµÄÓû§
mysql_client_encoding -- ·µ»Ø×Ö·û¼¯µÄÃû³Æ
mysql_close -- ¹Ø±Õ MySQL Á¬½Ó
mysql_connect -- ´ò¿ªÒ»¸öµ½ MySQL ·þÎñÆ÷µÄÁ¬½Ó
mysql_c ......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖظ´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âÇ°£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Ê ......
etting up OpenLDAP with MySQL backend
ÓÃmysql×÷ºǫ́Êý¾Ý¿â°²×°openldap
author: TBONIUS
OpenLDAP is an X.500 Lightweight Directory Access Server used for
centralized authentication and directory lookups. ......