Install MySQL on Fedora 10

Install MySQL on Fedora 10

create group/user:
$/usr/sbin/groupadd mysql
$/usr/sbin/useradd -c "MySQL Software Owner" -g mysql mysql
$passwd mysql

install mysql
$su
-
 

$yum install mysql mysql-devel mysql-server mysql-administrator

Start the server
$/etc/init.d/mysqld start

change the root admin passwd
$mysqladmin -u root password

make additional security-related changes to mysql.
$ mysql -u root -p
mysql> DROP DATABASE test; [removes the test database]
mysql> DELETE FROM mysql.user WHERE user = ; [Removes anonymous access]
mysql> FLUSH PRIVILEGES;

create databases and users
mysql> CREATE DATABASE web_db;
mysql> GRANT ALL PRIVILEGES ON web_db.* TO 'web_user'@'localhost' IDENTIFIED BY 'thepassword'

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]