Wei's blog

openssl req -new -x509 -days 365 -sha1 -newkey rsa:1024 \
-nodes -keyout server.key -out server.crt \
-subj '/O=Company/OU=Department/CN=www.example.com'

yum install mod_ssl
and update the ssl.conf file w/ the new key and cert

# chkconfig mysqld on
# /etc/init.d/mysqld start

mysqladmin -u root password NEWPASSWORD

for redhat:

service mysqld start/stop

mysql -u root -h localhost
(should change password after first login)

show databases;

use database;

show tables;

# mysql -u root -p
use mysql;
INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
flush privileges;