I am trying to install this from the source but can't seem to get it working properly. I probably missed some steps from the install manual:
useradd -g mysql mysql
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql
cp support-files/my-medium.cnf /etc/my.cnf
/usr/local/mysql/bin/safe_mysqld --user=mysql &
I am getting confused as to when i put this in:
/usr/local/mysql/bin/mysqladmin -u root -p password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h mywebsite.com -p password 'new-password'
I get all these error but am not expert enough to figure how to fix it:
/usr/local/mysql/bin/mysqladmin -u mysql -p password 'mypassword'
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'mysql@localhost' (Using password: YES)'
What I am looking for is the exact command lines to install mysql from scratch and to set it up with a password protection for root & any users.
I have a gateway 6400 server, 8GB HDD, 512MB ram.
Thanks in advance.