* Tyler Hall (
plug@webfreaks.com) wrote:
> I installed MYSQL lately, and ran into the weirdest problem. I'm wondering
> if anyone else has had this problem:
>
> It shows that it is running;
>
> [root@gizmo tyler]# mysqladmin ping -p
> Enter password:
> mysqld is alive
> [root@gizmo tyler]# mysqld
> 010503 7:37:04 Can't start server: Bind on TCP/IP port: Address already in
> use
> 010503 7:37:04 Do you already have another mysqld server running on port:
> 3306 ?
> 010503 7:37:04 Aborting
>
> [root@gizmo tyler]# telnet localhost 3306
> Trying 127.0.0.1...
> Connected to localhost.localdomain.
> Escape character is '^]'.
> NHost 'localhost.localdomain' is not allowed to connect to this MySQL
> serverConnection closed by foreign host.
>
> I can even telnet to the port, but thats not the point. I'm trying to
> get PHPSlash, or PHPMyAdmin to work with it, and it won't let me connect to
> it. It says it's not active (not running). Is there a place where I need
> to specifiy to let all web connections access it? That sounds funny, but I
> have no other solution to this problem. I can do a mysqladmin create
> database > something.so or whatever, and it will create it, but nothing on
> the web will be able to connect to the database.
>
> Thanks,
>
> Tyler
>
Have you set your permissions in the mysql database for your users?
Is it available via socket or TCP? If it's default setup you should be
able to
% mysql
and get a client, that is if you haven't set a root password, if you have:
% mysql -u root --password=MYPASS
then you'll be at a mysql prompt, check the status and see some variables:
mysql> \s
-or-
mysql> status
On my system this looks like:
---- terminal output ----
> mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 3.22.27
Type 'help' for help.
mysql> status
--------------
mysql Ver 9.36 Distrib 3.22.27, for pc-linux-gnu (i586)
Connection id: 6
Current database:
Current user: gontran@localhost
Server version 3.22.27
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 17 days 18 hours 49 min 27 sec
Threads: 1 Questions: 36 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2
--------------
mysql>
---- terminal output ----
Hth,
Gontran
(text/plain)