华南俳烁实业有限公司

mysqld 服務(wù)成功啟動(dòng)

[root@lly support-files]# netstat -tupln |grep mysqld

tcp 0 0 :::3306 :::*

[root@lly support-files]# cd ..

[root@lly mysql]# pwd

/usr/local/mysql

[root@lly mysql]# vim /etc/profile

重新登錄一次

[root@lly ~]# mysql

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| test |

+--------------------+

4 rows in set (0.00 sec)

[root@lly ~]# mysqladmin -u root -p password '123'設(shè)置一個(gè)管理員帳號(hào)密碼123

[root@lly ~]# mysql -u root -p以后就可以以此帳號(hào)登陸了

mysql生成的/usr/local/mysql/lib庫文件不是標(biāo)準(zhǔn)路徑系統(tǒng)無法識(shí)別（/lib 或者/usr/lib為標(biāo)準(zhǔn)路徑）所以需做如下配置

[root@lly mysql]# vim /etc/ld.so.conf.d/mysql.conf

寫入

/usr/local/mysql/lib

刷新ld.so.cache

[root@lly mysql]# ll /etc/ld.so.cache

-rw-r--r-- 1 root root 81871 Apr 13 08:17 /etc/ld.so.cache

[root@lly mysql]# ldconfig

[root@lly mysql]# ll /etc/ld.so.cache

-rw-r--r-- 1 root root 82128 Apr 13 15:46 /etc/ld.so.cache

對(duì)mysql的頭文件include做一個(gè)連接

[root@lly mysql]# ln -s /usr/local/mysql/include/ /usr/include/mysql