MySQL problem

Crystal™ · March 23, 2017

I reninstalled my os from 10.3 32bit to 64bit because i had this trouble:

After that i made the same exactly installation like i was doing on 9.3 and i did on 10.3 and i had a really strange problem, i can run perfectly commands , the mysql is running but i can't login into navicat .

Here is all my errors of db:

Spoiler

170323 22:37:16 mysqld_safe mysqld from pid file /var/db/mysql/root599313.kms4.cc.pid ended
2017-03-23 22:37:16 19527 [Note] Plugin 'FEDERATED' is disabled.
2017-03-23 22:37:16 19527 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-03-23 22:37:16 19527 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-23 22:37:16 19527 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-23 22:37:16 19527 [Note] InnoDB: Memory barrier is not used
2017-03-23 22:37:16 19527 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-03-23 22:37:16 19527 [Note] InnoDB: Using CPU crc32 instructions
2017-03-23 22:37:16 19527 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-23 22:37:16 19527 [Note] InnoDB: Completed initialization of buffer pool
2017-03-23 22:37:16 19527 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-03-23 22:37:16 19527 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-03-23 22:37:16 19527 [Note] InnoDB: Database physically writes the file full: wait...
2017-03-23 22:37:17 19527 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-03-23 22:37:17 19527 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-03-23 22:37:17 19527 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-03-23 22:37:17 19527 [Warning] InnoDB: New log files created, LSN=45781
2017-03-23 22:37:17 19527 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-03-23 22:37:17 19527 [Note] InnoDB: Doublewrite buffer created
2017-03-23 22:37:17 19527 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-23 22:37:17 19527 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-03-23 22:37:17 19527 [Note] InnoDB: Foreign key constraint system tables created
2017-03-23 22:37:17 19527 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-03-23 22:37:17 19527 [Note] InnoDB: Tablespace and datafile system tables created.
2017-03-23 22:37:17 19527 [Note] InnoDB: Waiting for purge to start
2017-03-23 22:37:17 19527 [Note] InnoDB: 5.6.35 started; log sequence number 0
2017-03-23 22:37:17 19527 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2017-03-23 22:37:17 19527 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2017-03-23 22:37:17 19527 [Note] Server hostname (bind-address): '*'; port: 3306
2017-03-23 22:37:17 19527 [Note] IPv6 is available.
2017-03-23 22:37:17 19527 [Note] - '::' resolves to '::';
2017-03-23 22:37:17 19527 [Note] Server socket created on IP: '::'.
2017-03-23 22:37:17 19527 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2017-03-23 22:42:36 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:37 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:38 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:38 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:38 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:39 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:39 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:41 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:42:45 19527 [ERROR] Invalid (old?) table or database name 'user - Copy'
2017-03-23 22:43:04 19527 [Note] /usr/local/libexec/mysqld: Normal shutdown

2017-03-23 22:43:04 19527 [Note] Giving 3 client threads a chance to die gracefully
2017-03-23 22:43:04 19527 [Note] Shutting down slave threads
2017-03-23 22:43:06 19527 [Note] Forcefully disconnecting 3 remaining clients
2017-03-23 22:43:06 19527 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 4 user: 'root'

2017-03-23 22:43:06 19527 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 1 user: 'root'

2017-03-23 22:43:06 19527 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 2 user: 'root'

2017-03-23 22:43:06 19527 [Note] Binlog end
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'partition'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_METRICS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_CMP'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'INNODB_TRX'
2017-03-23 22:43:06 19527 [Note] Shutting down plugin 'InnoDB'
2017-03-23 22:43:06 19527 [Note] InnoDB: FTS optimize thread exiting.
2017-03-23 22:43:06 19527 [Note] InnoDB: Starting shutdown...
2017-03-23 22:43:07 19527 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'BLACKHOLE'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'ARCHIVE'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'MRG_MYISAM'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'MyISAM'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'MEMORY'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'CSV'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'sha256_password'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'mysql_old_password'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'mysql_native_password'
2017-03-23 22:43:07 19527 [Note] Shutting down plugin 'binlog'
2017-03-23 22:43:07 19527 [Note] /usr/local/libexec/mysqld: Shutdown complete

170323 22:43:47 mysqld_safe Logging to '/var/db/mysql/root599313.kms4.cc.err'.
170323 22:43:48 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2017-03-23 22:43:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-23 22:43:50 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.35) starting as process 716 ...
2017-03-23 22:43:50 716 [Note] Plugin 'FEDERATED' is disabled.
2017-03-23 22:43:50 716 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-03-23 22:43:50 716 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-23 22:43:50 716 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-23 22:43:50 716 [Note] InnoDB: Memory barrier is not used
2017-03-23 22:43:50 716 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-03-23 22:43:50 716 [Note] InnoDB: Using CPU crc32 instructions
2017-03-23 22:43:50 716 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-23 22:43:50 716 [Note] InnoDB: Completed initialization of buffer pool
2017-03-23 22:43:50 716 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-23 22:43:50 716 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-23 22:43:50 716 [Note] InnoDB: Waiting for purge to start
2017-03-23 22:43:50 716 [Note] InnoDB: 5.6.35 started; log sequence number 1600607
2017-03-23 22:43:50 716 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2017-03-23 22:43:50 716 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2017-03-23 22:43:50 716 [Note] Server hostname (bind-address): '*'; port: 3306
2017-03-23 22:43:50 716 [Note] IPv6 is available.
2017-03-23 22:43:50 716 [Note] - '::' resolves to '::';
2017-03-23 22:43:50 716 [Note] Server socket created on IP: '::'.
2017-03-23 22:43:51 716 [Note] Event Scheduler: Loaded 0 events
2017-03-23 22:43:51 716 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution

Something else strange is that when I am running these commands and delete the error files I can login into navicat but after crashes again.

Spoiler

/usr/local/etc/rc.d/mysql-server stop

mysqld_safe --skip-grant-tables

Thanks for reading my post , wishing the best for all of you guys.

iltizio · March 23, 2017

You should learn the basic of mysql or you will loose a lot of time and you will male disasters.

Ti grant remote access, read this tutorial https://easyengine.io/tutorials/mysql/remote-access/

Crystal™ · March 27, 2017

On 3/23/2017 at 3:17 PM, iltizio said:

You should learn the basic of mysql or you will loose a lot of time and you will male disasters.

Ti grant remote access, read this tutorial https://easyengine.io/tutorials/mysql/remote-access/

dir /etc/mysq; doesn't exist..is it strange?

iltizio · March 27, 2017

it's my.cnf. Search with find or locate command.

Try without change my.cnf

If you can't find my.cnf, it means you use default settings. Search the documentation of your mysql version.

Sign In

MySQL problem

Recommended Posts

Crystal™ 25

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

iltizio 212

Link to comment

Share on other sites

Crystal™ 25

Link to comment

Share on other sites

iltizio 212

Link to comment

Share on other sites

Please sign in to comment

Announcements

Similar Content

Activity

LUA Questions

Ulthar SF V2 (TMP4 Base)

Shaman Skills Problem

[C++] Renewal For GM's /full_set Commands

Metin2 Rain Files 2007

System Wiki Kory

[C++] Renewal For GM's /full_set Commands

Football Ground

Assign "X" key to a side panel button in inventory

Recently Browsing

Community

My Activity Streams

Store

Tools

Important Information