How to Connect Windows to Centos
#2

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



Messages In This Thread
[No subject] - by lordzik112 - 04-07-2013, 08:13 AM
[No subject] - by Gothic - 04-07-2013, 08:30 AM
[No subject] - by dethunter12 - 04-07-2013, 08:57 AM
[No subject] - by linoskoczek - 04-09-2013, 01:59 PM
[No subject] - by lordzik112 - 04-10-2013, 08:11 AM
[No subject] - by Sutton - 04-14-2013, 12:46 AM
[No subject] - by RomainLastChaos - 06-06-2013, 02:43 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)