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 µÄÐ¶ÔØºÍ°²×°
Ò»¡¢Ç°ÆÚ×¼±¸£º
1
.ÓÉÓÚredhat Enterprise 5 ÖÐ×Ô´øÒ»¸ömysqlµÄ°æ±¾£¬Èç¹ûÔÚ°²×°linuxǰδѡÔñmysqlµÄ°²×°´Ë²½¾Í¿ÉÌø¹ý£¬ÒòΪÎÒµ±Ê±°²×°ÁËÏÖÔÚ½«ÆäÐ¶ÔØ
£¬²½ÖèÈçÏ£º
&nb ......
MySQLµÄ»ù±¾ÃüÁî
¡¡¡¡[ ]ÖеÄÄÚÈÝΪ¿ÉÑ¡Ïî
¡¡¡¡--´´½¨Êý¾Ý¿â
¡¡¡¡mysql> create database Êý¾Ý¿âÃû³Æ
¡¡¡¡--´´½¨±í
¡¡¡¡mysql> create table ±íÃû (
¡¡¡¡ÁеÄÃû×Ö£¨id£©ÀàÐÍ£¨int£¨4£©£©primary key(¶¨ÒåÖ÷¼ü) auto_increment£¨ÃèÊö ×ÔÔö£©,
¡¡¡¡……£¬
¡¡¡¡£©£»
¡¡¡¡--²é¿´ËùÓÐÊý¾Ý¿â
¡¡¡¡mys ......
ÒýÓà ҹÂä¹ÅÁú µÄ MySql Administrator µÄ¼òµ¥Ê¹Óã¨Í¼£©
MySQL AdministratorÌṩͼÐνçÃæÒÔ°ïÖúÄã¹ÜÀíMySQLÊý¾Ý¿â£¬WindowsÓû§¿ÉÒÔͨ¹ýÃüÁîÌáʾÐÐÔËÐÐMySQL
Administrator£¬ÔÚÓàÏÂʱ¼äÀïÎÒ¼Ù¶¨ÄãÒѾ°²×°ÁËMySQL Administrator£¬²¢ÇÒ½«Ê¹ÓÃÏà¹ØÍ¼Àý¡£
MySQL
AdministratorÖ÷½çÃæ
¡¡¡¡´´½¨Êý¾Ý¿â
......
·½·¨Ò»
ʹÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
·½·¨¶þ
ʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£
mysqladmin -u root -p password mypasswd
ÊäÈëÕâ¸öÃüÁîºó£¬ÐèÒªÊäÈërootµÄÔÃÜÂ룬ȻºórootµÄÃÜÂ뽫¸ÄΪmypasswd¡£
°ÑÃüÁîÀïµÄroot¸ÄΪÄãµÄÓû§Ãû£¬Äã¾Í¿ÉÒ ......
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 ......