MySQL

  • cyber_craft
  • Graduate
  • Graduate
  • User avatar
  • Posts: 163
  • Loc: USA

Post 3+ Months Ago

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
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • eWebtricity
  • Novice
  • Novice
  • User avatar
  • Posts: 23
  • Loc: Tampa, Florida

Post 3+ Months Ago

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
  • PsyckBoy
  • Posts: 204
  • Loc: SoCal

Post 3+ Months Ago

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
  • Posts: 163
  • Loc: USA

Post 3+ Months Ago

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

Post 3+ Months Ago

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

Post Information

  • Total Posts in this topic: 5 posts
  • Users browsing this forum: No registered users and 58 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
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.