how update mysql

It's most likely you've got depreciated instructions in your /etc/my.cnf.

If you find it hard to solve the issue yourself, even after reading error logs here /var/lib/mysql/server.reyhanhost.ir.err you may post last lines here so we check it for you. Otherwise please hire somebody from us to fix it for you.
 
You can not start mysql

/var/lib/mysql/server.reyhanhost.ir.err
server.reyhanhost.ir.err* :

Code: 
150326 16:23:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-03-26 16:23:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-26 16:23:17 17211 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2015-03-26 16:23:17 17211 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-03-26 16:23:17 17211 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-03-26 16:23:17 17211 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-26 16:23:17 17211 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2015-03-26 16:23:17 17211 [Note] InnoDB: Memory barrier is not used
2015-03-26 16:23:17 17211 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-26 16:23:17 17211 [Note] InnoDB: Using Linux native AIO
2015-03-26 16:23:17 17211 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-26 16:23:17 17211 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-26 16:23:17 17211 [Note] InnoDB: Completed initialization of buffer pool
2015-03-26 16:23:17 17211 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2015-03-26 16:23:17 17211 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2015-03-26 16:23:17 17211 [ERROR] Plugin 'InnoDB' init function returned error.
2015-03-26 16:23:17 17211 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-03-26 16:23:17 17211 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-03-26 16:23:17 17211 [ERROR] Aborting

2015-03-26 16:23:17 17211 [Note] Binlog end
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'partition'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'ARCHIVE'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'CSV'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'MyISAM'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'MEMORY'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'sha256_password'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'mysql_old_password'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'mysql_native_password'
2015-03-26 16:23:17 17211 [Note] Shutting down plugin 'binlog'
2015-03-26 16:23:17 17211 [Note] /usr/sbin/mysqld: Shutdown complete

150326 16:23:17 mysqld_safe mysqld from pid file /var/lib/mysql/server.reyhanhost.ir.pid ended
 
You can not start mysql

my.conf :
Code: 
[mysqld]
local-infile=0
safe-show-database
back_log = 50
#skip-innodb
max_connections = 500
key_buffer_size = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 256
wait_timeout = 200
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 4
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
range_alloc_block_size = 4096
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 8
pid-file=/var/lib/mysql/server01.reisforum.info.pid
socket          = /var/lib/mysql/mysql.sock

[mysqld_safe]
nice = -5
open_files_limit = 8192
log-error=/var/log/mysqld.log
pid-file=/var/lib/mysql/server01.reisforum.info.pid

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
 
Try to start your MySQL server with empty /etc/my.cnf
It seems you copied it from server01.reisforum.info without modification.
 
You can not start mysql

zEitEr said:
A listing from that page is for MySQL 4.x. You should never use my.cnf copied from internet. Please either get someone who has experience to write it for you or use special tools for that: https://tools.percona.com/wizard
Click to expand...
The code generated by the above site.
But still will not start.
Your username and password will give away your true?
 
You must log in or register to reply here.
Back
Top