running postinstall script (if any) + mysql_datadir=/var/lib/mysql + test ! -d /var/lib/mysql + test ! -d /var/lib/mysql/mysql + test ! -d /var/lib/mysql/test + /sbin/chkconfig --add mysql + useradd -M -r -d /var/lib/mysql -s /bin/bash -c MySQL server mysql + true + chown -R mysql /var/lib/mysql + mysql_install_db -IN-RPM PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://www.tcx.se/license.htmy. + chown -R mysql /var/lib/mysql + /etc/rc.d/init.d/mysql start + sleep 2 Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended D: removing old versions of package # blanks are "anything". # user table over-rides db table settings. DO NOT FORGET TO DO THIS AFTER ANY CHANGES!!! mysqladmin reload mysql -vvv mysql ##insert into user (host,user,password) values('localhost','dummy','',''); INSERT INTO user VALUES ('localhost','nobody','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); INSERT INTO user VALUES ('209.20.180.%','root',password('oct1497'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); INSERT INTO user VALUES ('209.20.180.167','daevid',password('XXXXXXXX'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N'); INSERT INTO user VALUES ('localhost','jez','','Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N'); INSERT INTO user VALUES ('209.20.180.161','jez','','Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N'); INSERT INTO user VALUES ('209.43.128.%','jez',password('oct1497'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N'); INSERT INTO user VALUES ('209.43.129.%','jez',password('oct1497'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N'); INSERT INTO user VALUES ('%.accessone.com','jez',password('oct1497'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N'); #delete from user where User like 'bruce' and Host like '209.20.180.%'; INSERT INTO user VALUES ('209.20.180.%','bruce','','Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N'); INSERT INTO user VALUES ('localhost','bruce','','Y','Y','Y','Y','Y','Y','N','N','N','N','N','N','N','N'); ###update user set Password = password('oct1497') where User like "bruce" AND Host like "209.20.180.%"; ###delete from user where User like 'daevid' and Host like '209.20.180.%'; select * from user where Password = password('oct1497'); user table: +------------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +------------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | %wildtangent.com | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | | | N | N | N | N | N | N | N | N | N | N | N | Y | Y | Y | | %wildtangent.com | | | N | N | N | N | N | N | N | N | N | N | N | Y | Y | Y | | localhost | nobody | 5185fe892806f467 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | %WildTangent.com | nobody | 5185fe892806f467 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | 209.20.180.% | nobody | 5185fe892806f467 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | daevid | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | %WildTangent.com | daevid | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | 209.20.180.% | bruce | 7ea0fc3b7a17ef20 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | | localhost | impmgr | 5567401602cd5ddd | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | localhost | bruce | | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | N | N | | 209.20.180.% | root | 5185fe892806f467 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | youngsys | 3deca0314582ce3e | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | jez | | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | | 209.20.180.169 | jez | | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | | 209.20.180.167 | daevid | 3f294163316d3bf2 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | | 209.20.180.161 | jez | | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | | 209.43.128.% | jez | 5185fe892806f467 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | | 209.43.129.% | jez | 5185fe892806f467 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | | %.accessone.com | jez | 5185fe892806f467 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | +------------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ 21 rows in set (0.01 sec) insert into db values ('%','wt_client','daevid','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); insert into db values ('localhost','cris_cddb','jez','N','N','N','N','N','N','N','N','N','N'); insert into db values ('localhost','wt_bug','bruce','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); ###delete from db where Db = 'wt_client'; db table: +-----------+-----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+-----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ | % | test | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | test\_% | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | wt_bug | bruce | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | imp | impmgr | Y | Y | Y | Y | Y | Y | N | N | N | N | | localhost | cris_cddb | youngsys | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | cris_cddb | jez | N | N | N | N | N | N | N | N | N | N | +-----------+-----------+----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ 6 rows in set (0.00 sec) insert into host values ('%wildtangent.com','%','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); host table: +------------------+----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ | Host | Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +------------------+----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ | %wildtangent.com | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +------------------+----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ 2 rows in set (0.00 sec) DO NOT FORGET TO DO THIS AFTER ANY CHANGES!!! mysqladmin reload