Re: Error Connecting To Server From Client Machine-Linux

[Andy Pieters]

Hi Mark

You should know that users and passwords are specific to the host where they 
are being used.

For instance, if your root password on the server is mypass, and use it to 
connect to the mysql server, then it will get accepted.

Now if you use a mysql client on another machine to connect to the server and 
use the root account with password mypass then it will get rejected.

Check out the mysql documentation on the GRANT command.  You will see that it 
includes a hostname

Like GRANT ALL on database TO 'user'@'host` IDENTIFIED BY password

See http://dev.mysql.com/doc/mysql/en/grant.html

Kind regards


Andy

-- 
Registered Linux User Number 379093
-- --BEGIN GEEK CODE BLOCK-----
Version: 3.1
GAT/O/>E$ d-(---)>+ s:(+)>: a--(-)>? C++++$(+++) UL++++>++++$ P-(+)>++
L+++>++++$ E---(-)@ W+++>+++$ !N@ o? !K? W--(---) !O !M- V-- PS++(+++)
PE--(-) Y+ PGP++(+++) t+(++) 5-- X++ R*(+)@ !tv b-() DI(+) D+(+++) G(+)
e>++++$@ h++(*) r-->++ y--()>++++
-- ---END GEEK CODE BLOCK------
--
Check out these few php utilities that I released
 under the GPL2 and that are meant for use with a 
 php cli binary:
 
 http://www.vlaamse-kern.com/sas/
--

--

Attachment: [application/pgp-signature]