Mysql >navicat error

[Baloe 6]

Hey,

I have just one question ..

I just installed in my mysql freebsd vps , but now I see an error when I try to log in navicat :



Does anyone know a solution?

Thanks in advance.

Sorry for me bad english

[iltizio 212]

Locate your my.cnf file and comment line  "bind-address"

Nextly verify if root user can connect from all hosts (root@%)

[Baloe 6]

3 hours ago, iltizio said:

Locate your my.cnf file and comment line  "bind-address"

Nextly verify if root user can connect from all hosts (root@%)

Hey,

Thanks for your comment.

In my my.cnf is this :

 

 

 

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
 

[iltizio 212]

And so do the second thing: check if root user can login from all hosts.

You need to have root@% user to connect from other host.

 

[Baloe 6]

11 hours ago, iltizio said:

And so do the second thing: check if root user can login from all hosts.

You need to have root@% user to connect from other host.

 

Hey,

Thanks for your comment.

But, I took a look on google and when I came to this site and have also followed him,

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

But without success .. Get now see another error in navicat :

2003- Can't connectto MySQL server on '*****' (10038)

And that if I
mysql -u root -p mysql run in freebsd

 

 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mys         ql.sock' (2)
 

[iltizio 212]

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mys         ql.sock' (2)
 This mean your mysql-server is down.

Start it with:

service mysql-server start

[Baloe 6]

1 hour ago, iltizio said:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mys         ql.sock' (2)
 This mean your mysql-server is down.

Start it with:

service mysql-server start

 

Thanks for your comment!

 

I've already done a few times without success .. But now I happen to be an error in the error log I see the site what comes out :

http://textuploader.com/58xnm

 

Only , if I just google them to upgrade it over to mysql , and the problem is gone or something .. ?

[iltizio 212]

There are something wrong in your installation.

If you can I suggest you to deinstall mysql-server and remove /var/db/mysql directory. Nextly install a new mysql server or (suggested) MariaDB 

 

[Baloe 6]

7 hours ago, iltizio said:

There are something wrong in your installation.

If you can I suggest you to deinstall mysql-server and remove /var/db/mysql directory. Nextly install a new mysql server or (suggested) MariaDB 

 

Thanks for your comment

 

I have now installed MariaDB But, if I '' service mysql -server ' ' do than just starting and I can also: mysql -u root -p mysql and then fill me pass word and then I come out on

 

> mysql

 

But, if I fill in my ip navicat then there will still be this :  2003 - Can not connect to MySQL server on ' ( my host ip) ( 10038 )

 

[iltizio 212]

http://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html

Here you can find a lot of checks. Remember you use FreeBSD and MariaDB.

Firstly do this command to check if your MariaDB server is listen correctly:

netstat -na | grep 3306 | grep LISTEN

And post here the output.

 

Remember also to create root@℅ user because is not created on default installation.

[Baloe 6]

3 hours ago, iltizio said:

http://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html

Here you can find a lot of checks. Remember you use FreeBSD and MariaDB.

Firstly do this command to check if your MariaDB server is listen correctly:

netstat -na | grep 3306 | grep LISTEN

And post here the output.

 

Remember also to create root@℅ user because is not created on default installation.

 

Thanks for your comment!

 

I had him incorrectly installed .. So I did it again and now everything worked except for one thing .. I get back to see this error message:

 

1130 - Host 095-097-232-076.static.chello.nl'is not allowed to connnect to this MariaDB

 

server What do I ever wrong?

[iltizio 212]

Check where you can login with root user with this query:

SELECT host FROM mysql.user WHERE User = 'root';

If you can't see a record with % you need to create root@% user:

CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

FLUSH PRIVILEGES;