04-07-2013, 08:30 AM
your Guide is .... omg noobs youse phpmyadmin on linux
$MySQL
set up the mysql accounts
login with the terminal as user root and use this commands :
mysql -u root -p
this will ask you for password if u not have set a password just hit enter
Generate an mysql User
GRANT ALL ON *.* TO myuser@% IDENTIFIED BY mypassword
example create user HateMe with password SuperMob
GRANT ALL ON *.* TO HateMe@% IDENTIFIED BY SuperMob
example create user LCSERVER with password MYSERVERROCKS only from ip 127.0.0.1 only
GRANT ALL ON *.* TO [email protected] IDENTIFIED BY MYSERVERROCKS
to use the account LCSERVER for the files we need now to change the password to old_password
UPDATE mysql.user SET password=OLD_PASSWORD(MYSERVERROCKS) WHERE user=LCSERVER;
to make all this effects works waht we have done we need type
flush privileges;
now we can leave the mysql line with
quit
By HateMe

