Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql °²×°

Ò»¡¢°²×°
#
yum -y install mysql-server
¶þ¡¢ÅäÖÃ
# vi /etc/my.cnf¡¡ ← ±à¼­MySQLµÄÅäÖÃÎļþ
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1¡¡ ← ÕÒµ½ÕâÒ»ÐУ¬ÔÚÕâÒ»ÐеÄÏÂÃæÌí¼ÓÐµĹæÔò£¬ÈÃMySQLµÄĬÈϱàÂëΪUTF-8
default-character-set = utf8¡¡ ← Ìí¼ÓÕâÒ»ÐÐ
È»ºóÔÚÅäÖÃÎļþµÄÎÄβÌî¼ÓÈçÏÂÓï¾ä£º
[mysql]
default-character-set = utf8
Èý¡¢Æô¶¯MySQL£¬²¢ÈÃMySQLÔÚÏµÍ³ÖØÐÂÆô¶¯ºóËæÏµÍ³×Ô¶¯Æô¶¯
# chkconfig mysqld on
¡¡ ← ÉèÖÃMySQL·þÎñËæÏµÍ³Æô¶¯×ÔÆô¶¯
# chkconfig --list mysqld
¡¡ ← È·ÈÏMySQL×ÔÆô¶¯
mysqld 0:off 1:off 2:on 3:on 4:on 5:on
6:off¡¡ ← Èç¹û2--5ΪonµÄ״̬¾ÍOK
#
/etc/rc.d/init.d/mysqld start
¡¡ ← Æô¶¯MySQL·þÎñ

Initializing MySQL database:¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ [
OK
]
Starting MySQL: ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡[
OK
]
ËÄ¡¢
ΪMySQLµÄrootÓû§ÉèÖÃÃÜÂë
MySQLÔÚ¸Õ¸Õ±»°²×°µÄʱºò£¬ËüµÄrootÓû§ÊÇûÓб»ÉèÖÃÃÜÂëµÄ¡£
Ê×ÏÈÀ´ÉèÖÃMySQLµÄrootÃÜÂë¡£
#
mysql -u root
¡¡ ← ÓÃrootÓû§µÇ¼MySQL·þÎñÆ÷

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
select user,host,password from mysql.user;
¡¡ ← ²é¿´Óû§ÐÅÏ¢
+------+------------------------------+---------------+
| user | host ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡| password¡¡|
+------+------------------------------+---------------+
| root | localhost¡¡¡¡¡¡¡¡ ¡¡¡¡¡¡| ¡¡¡¡¡¡¡¡¡¡¡¡|¡¡
← rootÃÜÂëΪ¿Õ

| root | sample.centospub.com¡¡ |¡¡¡¡¡¡¡¡¡¡¡¡ |¡¡
← rootÃÜÂëΪ


Ïà¹ØÎĵµ£º

linuxÏÂ×Ô´øµÄmysqlÐ¶ÔØºÍ°²×°

linuxÏ mysql µÄÐ¶ÔØºÍ°²×°
¹Ø¼ü×Ö: linuxÏ mysql µÄÐ¶ÔØºÍ°²×°

Ò»¡¢Ç°ÆÚ×¼±¸£º
    1
.ÓÉÓÚredhat Enterprise 5 ÖÐ×Ô´øÒ»¸ömysqlµÄ°æ±¾£¬Èç¹ûÔÚ°²×°linuxǰδѡÔñmysqlµÄ°²×°´Ë²½¾Í¿ÉÌø¹ý£¬ÒòΪÎÒµ±Ê±°²×°ÁËÏÖÔÚ½«ÆäÐ¶ÔØ
£¬²½ÖèÈçÏ£º
     &nb ......

³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ

MySQLµÄ»ù±¾ÃüÁî
¡¡¡¡[ ]ÖеÄÄÚÈÝΪ¿ÉÑ¡Ïî
¡¡¡¡--´´½¨Êý¾Ý¿â
¡¡¡¡mysql> create database Êý¾Ý¿âÃû³Æ
¡¡¡¡--´´½¨±í
¡¡¡¡mysql> create table ±íÃû (
¡¡¡¡ÁеÄÃû×Ö£¨id£©ÀàÐÍ£¨int£¨4£©£©primary key(¶¨ÒåÖ÷¼ü) auto_increment£¨ÃèÊö ×ÔÔö£©,
¡¡¡¡……£¬
¡¡¡¡£©£»
¡¡¡¡--²é¿´ËùÓÐÊý¾Ý¿â
¡¡¡¡mys ......

MySql Administrator µÄ¼òµ¥Ê¹Óã¨Í¼£©

ÒýÓà ҹÂä¹ÅÁú µÄ MySql Administrator µÄ¼òµ¥Ê¹Óã¨Í¼£©
 
 
MySQL AdministratorÌṩͼÐνçÃæÒÔ°ïÖúÄã¹ÜÀíMySQLÊý¾Ý¿â£¬WindowsÓû§¿ÉÒÔͨ¹ýÃüÁîÌáʾÐÐÔËÐÐMySQL
Administrator£¬ÔÚÓàÏÂʱ¼äÀïÎÒ¼Ù¶¨ÄãÒѾ­°²×°ÁËMySQL Administrator£¬²¢ÇÒ½«Ê¹ÓÃÏà¹ØÍ¼Àý¡£
MySQL
AdministratorÖ÷½çÃæ
¡¡¡¡´´½¨Êý¾Ý¿â ......

ÐÞ¸ÄMYSQLÃÜÂëºÍÃÜÂëÆÆ½âµÄ³£Ó÷½·¨

·½·¨Ò»
ʹÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
·½·¨¶þ
ʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£
mysqladmin -u root -p password mypasswd
ÊäÈëÕâ¸öÃüÁîºó£¬ÐèÒªÊäÈërootµÄÔ­ÃÜÂ룬ȻºórootµÄÃÜÂ뽫¸ÄΪmypasswd¡£
°ÑÃüÁîÀïµÄroot¸ÄΪÄãµÄÓû§Ãû£¬Äã¾Í¿ÉÒ ......

how to install apache, PHP and MySQL on Linux 2

how to install apache, PHP and MySQL on Linux
This tutorial explains the installation of Apache web server, bundled
with PHP and MySQL server on a Linux machine. The tutorial is primarily for SuSE
9.2, 9.3, 10.0 & 10.1, but most of the steps ought to be valid for all
Linux-like operating ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ