LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-15-2005, 07:52 AM   #1
bentschmidt
LQ Newbie
 
Registered: Jun 2005
Posts: 2

Rep: Reputation: 0
Post Mysql Administrator Program


I have installed Mysql, Apache and PHP on Suse 9.2 on an single pc connected to my network.

I then installed the Mysql Administrator Program on my Windows XP computer to administrate my Mysql. But I can't get access to the Mysql server throug the Mysql Administrator Program

I can start the PHPmyadmin via the browser and see the Mysql databases test and mysql and make rights etc..


I need some help from all you out there.

k.r.
bentschmidt
 
Old 06-15-2005, 08:08 AM   #2
perfect_circle
Senior Member
 
Registered: Oct 2004
Location: Athens, Greece
Distribution: Slackware, arch
Posts: 1,783

Rep: Reputation: 52
Is mysql's root account accessible from outside your computer?

Code:
skalkoto@darkstar:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT user, host FROM mysql.user;
+-------+-----------+
| user  | host      |
+-------+-----------+
| snort |           |
| snort | %         |
| root  | darkstar  |
| root  | localhost |
+-------+-----------+
4 rows in set (0.00 sec)

mysql>
In my case only localhost and darkstar (which is the local host name) can access the root account.

*EDIT*
Also check if there is a firewall in your linux box blocking the mysql port (3306 is the default mysql port)

Last edited by perfect_circle; 06-15-2005 at 08:11 AM.
 
Old 06-15-2005, 08:37 AM   #3
bentschmidt
LQ Newbie
 
Registered: Jun 2005
Posts: 2

Original Poster
Rep: Reputation: 0
I tried the same as you and the following came up on my screen:

bes@linux:~> mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 71 to server version: 4.0.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT user, host FROM mysql.user;
+------+------------+
| user | host |
+------+------------+
| | linux.site |
| bes | linux.site |
| root | linux.site |
| | localhost |
| root | localhost |
+------+------------+
5 rows in set (0.00 sec)

mysql>
 
Old 06-15-2005, 09:15 AM   #4
perfect_circle
Senior Member
 
Registered: Oct 2004
Location: Athens, Greece
Distribution: Slackware, arch
Posts: 1,783

Rep: Reputation: 52
Quote:
Originally posted by bentschmidt
I tried the same as you and the following came up on my screen:

bes@linux:~> mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 71 to server version: 4.0.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT user, host FROM mysql.user;
+------+------------+
| user | host |
+------+------------+
| | linux.site |
| bes | linux.site |
| root | linux.site |
| | localhost |
| root | localhost |
+------+------------+
5 rows in set (0.00 sec)

mysql>
You have 2 anonymous accounts (1 , 4) the root accounts (3, 5) and a bes account.
You can connect as root only from localhost and linux.site (I get the feeling that those are the same host).
If you want to be able to connect as root from somewhere you need a new root user.
Use the "grant" command to do this.
Something like :
grant <all the permisions you want> on *.* to root@<IP or host>;
SET PASSWORD FOR root@<IP or host> = PASSWORD('the_password_you_want');
Leaving the <IP or host> blank will let you connect from anywhere. If you care about security, this is a bad thing to do.
The gui is fine but you need to know basic stuff in the mysql console.
Download and read the mysql manual. It's all written in there.

Also, you might consider dropping the anonymous accounts.
DELETE FROM mysql.user WHERE User= '';
FLUSH PRIVILEGES;
or even delete the test database:
DROP DATABASE test;
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Administrator Meabert Linux - Software 6 06-08-2006 04:46 AM
mysql administrator Joe_Zhu Linux - Software 5 06-22-2005 05:55 AM
Restoring MySQL backups with mysql-administrator pnellesen Programming 0 04-25-2005 10:53 AM
How access MySQL by MySQL Administrator? treotan Linux - Newbie 5 12-04-2004 11:17 PM
MySQL Administrator eva Linux - Software 3 08-28-2004 11:54 PM


All times are GMT -5. The time now is 10:39 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration