Remote access of MySQL

Remote access of MySQL

am 04.06.2011 22:30:10 von Abdul Vali

--90e6ba6e84e2c602a504a4e8bdf2
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Dear All

I have installed MySQL 5 on Ubuntu 10.04 Server. It is working fine but
when I try to access MySQL through any other client using ODBC connector, i=
t
says access is denied for user root.

It looks that MySQL remote access is blocked. Can someone suggest me which
variable to add or change in my.cnf file? or I have to change something els=
e
so that I can access MySQL databases from other computers using ODBC

--=20
Regards

Abdul Vali
Librarian - ASE School



Ata ur Rehman
------------------------------

AM Library,
National Centre for Physics(NCP),
Islamabad
http://www.ncp.edu.pk/
http://www.ncplib.co.cc/ Coordinator,
LISolutions®
info@lisolutions.org
http://www.lisolutions.org

My profiles: [image: Facebook] [image=
:
LinkedIn] [image:
Flickr] [image:
Twitter] [image:
Blogger] [image:
Delicious]
Contact me: [image: Google Talk] ata.rehman [image: Skype] ata.rehman [imag=
e:
MSN] ata.rehman@gmail.com

--90e6ba6e84e2c602a504a4e8bdf2--

Re: Remote access of MySQL

am 04.06.2011 23:07:53 von Reindl Harald

--------------enig7E21D4636E5256F8E7B38300
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html

Am 04.06.2011 22:30, schrieb Abdul Vali:
> Dear All
>=20
> I have installed MySQL 5 on Ubuntu 10.04 Server. It is working fine bu=
t
> when I try to access MySQL through any other client using ODBC connecto=
r, it
> says access is denied for user root.
>=20
> It looks that MySQL remote access is blocked. Can someone suggest me w=
hich
> variable to add or change in my.cnf file? or I have to change something=
else
> so that I can access MySQL databases from other computers using ODBC


--------------enig7E21D4636E5256F8E7B38300
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk3qnqoACgkQhmBjz394AnlqywCdG3qF+6VpHLm4av93SSvv w1vA
woIAn3wES/yUcyPJ2Nxhb0e5x0skMmOV
=+yQr
-----END PGP SIGNATURE-----

--------------enig7E21D4636E5256F8E7B38300--