Back To Unix / Linux Forum

MySQL

  • cyber_craft
  • Graduate
  • Graduate
  • User avatar
  • Joined: Aug 17, 2004
  • Posts: 163
  • Loc: USA
  • Status: Offline

Post November 27th, 2005, 1:18 pm

Ok i downloaded MySQL the binary. and i have it started i gave a root password

BUT i cant connect to it
i can from the server if i do this
cd /usr/local/bin
./mysql

then i get the mysql client and it seems to connect to it. but if i try to do it
form another computer it will not do it

:shock:
please help
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post November 27th, 2005, 1:18 pm

  • eWebtricity
  • Novice
  • Novice
  • User avatar
  • Joined: Aug 22, 2005
  • Posts: 23
  • Loc: Tampa, Florida
  • Status: Offline

Post November 27th, 2005, 7:00 pm

you might be running a firewall on the box with MySQL which is preventing other machines from connecting. Also you need to make sure the user account your using to connect permits connections from other hosts not only the localhost. You might check out phpMyAdmin for a web based graphical interface that makes it easier if your new to MySQL.

http://www.phpmyadmin.net
  • PsyckBoy
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Jun 20, 2005
  • Posts: 204
  • Loc: SoCal
  • Status: Offline

Post November 28th, 2005, 12:53 am

Look in /etc/mysql/my.conf for the skip-networking or bind-address options. If you find skip-networking, comment it out. If you find bind-address, change it to an address on the box other than 127.0.0.1. Note that this could be a potential security problem.
  • cyber_craft
  • Graduate
  • Graduate
  • User avatar
  • Joined: Aug 17, 2004
  • Posts: 163
  • Loc: USA
  • Status: Offline

Post December 8th, 2005, 4:37 pm

Thanks for all the help but i fingered it out thanks
  • bleepnik
  • Professor
  • Professor
  • User avatar
  • Joined: Feb 14, 2004
  • Posts: 971
  • Loc: South Jersey, US
  • Status: Offline

Post December 9th, 2005, 7:57 am

Can you tell us how you resolved it? The solution may help others who search the forum for an answer in the future.

Page 1 of 1

Post Information

  • Total Posts in this topic: 5 posts
  • Users browsing this forum: No registered users and 119 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.