[help] question?

[flyingwater]

is it possible to connect navicat to a mysql database in ubuntu, if so how?

[MentaL]

[343]

The same exact way you'd connect using anything else that would connect to it. Username/Password -- Of course if you're dealing with a default installation of MySQL it only has a user 'root' with no password '', which ONLY has access from LOCALHOST. If using a 'default' installation you must first either give user 'root' access from 'any host' OR create a new user with access from 'any host' (or of course you can assign a host etc...)

[das7002]

The same exact way you'd connect using anything else that would connect to it. Username/Password -- Of course if you're dealing with a default installation of MySQL it only has a user 'root' with no password '', which ONLY has access from LOCALHOST. If using a 'default' installation you must first either give user 'root' access from 'any host' OR create a new user with access from 'any host' (or of course you can assign a host etc...)

Actually incorrect, for security reasons many moons ago the default MySQL install only allows access from localhost no matter what the user permissions are. If you want to use Navicat with MySQL on a remote host use the magic SSH+MySQL feature it provides (which I've found somewhat nifty if I don't have phpMyAdmin installed yet)




(If you really want to use MySQL remotely completely unencrypted you'd have to edit the mysql.conf and remove the limit for localhost only)

[flyingwater]

Umm so, i'm asking because xAtticusx From JD said something about connecting to your ubuntu mysql server using navicat

[343]

Actually incorrect, for security reasons many moons ago the default MySQL install only allows access from localhost no matter what the user permissions are. If you want to use Navicat with MySQL on a remote host use the magic SSH+MySQL feature it provides (which I've found somewhat nifty if I don't have phpMyAdmin installed yet)




(If you really want to use MySQL remotely completely unencrypted you'd have to edit the mysql.conf and remove the limit for localhost only)

yes the default installation parameters only allow the user root access from within 'localhost' however you can EASILY change this setting for the user :p

I've done it 1,000,000 times, because I usually use NaviCat for my PW VM...NO SSH...NO editing mysql.conf... Just changing root/locahost to allow any host (or %)...

Spoiler:

I'm using MySQL 5.5.8 btw

[flyingwater]

so im going to have to install phpadmin for me to do that

[343]

Or of course if you don't have PHPMYADMIN installed you could do it straight though MySQL

mysql -uroot

use mysql;
select host, user from user;

then you should receive a response like this:
 
 Spoiler:  
 
 
    mysql> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Database changed

    mysql> select host,user from user;
    +—————+——————+
    | host | user |
    +—————+——————+
    | ubuntuserv | root |
    | localhost | debian-sys-maint |
    | localhost | root |
    +—————+——————+
    3 rows in set (0.00 sec)
 
 

update user set host=’%’ where user=’root’ and host=’localhost’;
flush privileges;

[flyingwater]

i tried it but it keeps saying access denied, and i'm using root

[343]

i tried it but it keeps saying access denied, and i'm using root

at which part? the very first part?

If this is happening to you at the very first part that means your 'root' has a password

---------- Post added at 05:37 AM ---------- Previous post was at 05:36 AM ----------

...and if this is the case you wouldn't even be able to create a new user with % host privileges because you wont be able to log in at all...

---------- Post added at 05:39 AM ---------- Previous post was at 05:37 AM ----------

if you have (and know) the password for user 'root' you need to change that first line to:

mysql -uroot -ppasswordhere

---------- Post added at 05:49 AM ---------- Previous post was at 05:39 AM ----------

If that is not the issue (root does not have a password) and you're getting problems giving root access from % host -- you can do this to add a new user with permission from % host:

mysql -uroot

CREATE USER 'new_username'@'%' IDENTIFIED BY 'password_for_new_username';

GRANT ALL ON *.* TO 'new_username'@'%';

[flyingwater]

i've tried to two things replacing ppasswordhere with my own password and just putting -ppasswordhere, but it says unknown option, and the second try it keeps saying access denied

[hrace009]

change use privileges with out change mysql.conf limit it will always denide.

one way

@mysql.conf change the limit to none or give # << this symbol.

and set your firewall only accept port 3306 from your local IP.