[solved]access mysql interface

[odin]

I installed mysql, how can i access to mysql interface?

[DrmCa]

You can install MySqlAdmin on another machine and connect to ZS IP and port#

[odin]

thanks i’ll try it, and what about phpmyadmin?

EDIT: i’m trying with mysql-workbench (i’m using ubuntu 15.10) and it say

"Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server"

I used admin and the admin pass.

mysqld log on zeroshell says:

IP address 'xxx.xxx.xxx.xxx' could not be resolved: Name or service not known

[DrmCa]

You have to google the 1st error, the 1st link I am getting has a good explanation.

[odin]

if you are referring to this https://stackoverflow.com/questions/19101243/error-1130-hy000-host-is-not-allowed-to-connect-to-this-mysql-server

mysql on zeroshell give me “command not found” and in /etc/ i don’t even have mysql folder

[DrmCa]

Your google must be getting you slightly different results.
I was referring to this linnk: http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server
Can you get into the command line tool on the server?

[odin]

Yes, and

mysql -u root -h localhost -p 

give me “mysql: command not found”

[DrmCa]

Sounds like install is broken. mysql command line tool should be there!

[odin]

A this point i believe the php problem is related to the broken installation, how can i reinstall (maybe with another iso) and preserve the activation?

[DrmCa]

That would be a question to Fulvio, i only had activation once long time ago and it since just expired, never migrated between the installations.

[odin]

Thanks, i’ll send him an email

[Author]

Posts