www.zeroshell.org Forum Index www.zeroshell.org
Linux Distribution for server and embedded devices
 
 SearchSearch  RegisterRegister  UsergroupsUsergroups 
 ProfileProfile  Log inLog in  Log in to check your private messagesPrivate Message 

[solved]access mysql interface

 
Post new topic   Reply to topic    www.zeroshell.org Forum Index -> ZeroShell
View previous topic :: View next topic  
Author Message
odin



Joined: 05 Jan 2016
Posts: 14

PostPosted: Sat Apr 16, 2016 4:25 pm    Post subject: [solved]access mysql interface Reply with quote

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

Last edited by odin on Fri Apr 29, 2016 9:36 am; edited 1 time in total
Back to top
View user's profile Send private message
DrmCa



Joined: 12 Apr 2011
Posts: 234

PostPosted: Mon Apr 18, 2016 9:16 pm    Post subject: Reply with quote

You can install MySqlAdmin on another machine and connect to ZS IP and port#
Back to top
View user's profile Send private message
odin



Joined: 05 Jan 2016
Posts: 14

PostPosted: Tue Apr 19, 2016 8:57 am    Post subject: Reply with quote

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

Code:
"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:

Code:
IP address 'xxx.xxx.xxx.xxx' could not be resolved: Name or service not known
Back to top
View user's profile Send private message
DrmCa



Joined: 12 Apr 2011
Posts: 234

PostPosted: Tue Apr 19, 2016 2:00 pm    Post subject: Reply with quote

You have to google the 1st error, the 1st link I am getting has a good explanation.
Back to top
View user's profile Send private message
odin



Joined: 05 Jan 2016
Posts: 14

PostPosted: Tue Apr 19, 2016 3:53 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
DrmCa



Joined: 12 Apr 2011
Posts: 234

PostPosted: Tue Apr 19, 2016 4:19 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
odin



Joined: 05 Jan 2016
Posts: 14

PostPosted: Tue Apr 19, 2016 4:35 pm    Post subject: Reply with quote

Yes, and
Code:
mysql -u root -h localhost -p

give me "mysql: command not found"
Back to top
View user's profile Send private message
DrmCa



Joined: 12 Apr 2011
Posts: 234

PostPosted: Tue Apr 19, 2016 4:54 pm    Post subject: Reply with quote

Sounds like install is broken. mysql command line tool should be there!
Back to top
View user's profile Send private message
odin



Joined: 05 Jan 2016
Posts: 14

PostPosted: Tue Apr 19, 2016 4:58 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
DrmCa



Joined: 12 Apr 2011
Posts: 234

PostPosted: Tue Apr 19, 2016 5:03 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
odin



Joined: 05 Jan 2016
Posts: 14

PostPosted: Tue Apr 19, 2016 5:50 pm    Post subject: Reply with quote

Thanks, i'll send him an email
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    www.zeroshell.org Forum Index -> ZeroShell All times are GMT
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group