Baloe

1 hour ago, iltizio said:

• Wrong password
• User mt2@localhost doesn't exist
• User mt2@localhost dowsn't have permissions

Thanks!

mysql> GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#' WITH GRANT OPTION;
mysql> Flush privileges;
mysql> quit

solved

Hey,

Since I booted my server I get to see this error:

I've already tried everything without success ..

1
Wieviele Channels sollen gestartet werden (max. 4)?
1
panel.sh: channel_count: not found
Der Server wird gestartet ...
Real Server
Log Offmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
 

hello,

I have a problem..

I happened to see this topic and have exactly the zelfe problem:

syserr:

SYSERR: Sep  4 09:40:28 :: BuildStateIndexToName: QUEST wrong quest state file for quest Eisland_W?chter
SYSERR: Sep  4 09:40:31 :: GetQuestStateIndex: QUEST wrong quest state file Eisland_W?chter.start
SYSERR: Sep  4 09:40:31 :: GetQuestStateIndex: QUEST wrong quest state file Eisland_W?chter.start
SYSERR: Sep  4 09:40:31 :: GetQuestStateIndex: QUEST wrong quest state file Eisland_W?chter.start
SYSERR: Sep  4 10:52:38 :: pid_init: 
Start of pid: 906

SYSERR: Sep  4 15:03:29 :: pid_init: 
Start of pid: 2011

SYSERR: Sep  4 15:57:31 :: pid_init: 
Start of pid: 986

https://metin2.download/picture/u97XnGe4J32g5X0NXX17Ps44gfBa10Ev/.png

sorry for my bad English

Maybe the image looks?
What is at CH1 ....

https://metin2.download/picture/r3F9504x09DVmF8K988YXgTtGTP6KMUj/.gif

solved

reboot the server

Now I have another question ..

All it is doing unless you go in the client than if you enter the correct data says that can not connect to the server .. And if you wrong data key will say the wrong data.

And he gives an error in the server:

http://textuploader.com/58pnt

hello,

I have a problem ..

I like my sh panel.sh start than I see an error:

http://textuploader.com/58pvo

Does anyone know a fix?

With a tutorial?

Thanks in advance!

sorry for my bad English

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?

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 )

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 .. ?

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)
 

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 
 

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

I would like to start a private server metin ,

Does anyone have a good tutorial where everything clearly state what to do / create? Because I walk still stuck at a point ..

I use FreeBSD 10.2 (VPS)


And then I have another question ,

If you mysql insteld then do say this :



$ cd /usr/ports/databases/mysql56-server

$ make BUILD_OPTIMIZED=yes BUILD_STATIC=yes

$ make WITH_XCHARSET=all install clean



And how to set your own password then ?

sorry for my bad English