Welcome! Log In Create A New Profile

Advanced

How to install MySQL?

Posted by Almaz 
Forum List Message List New Topic
Almaz
How to install MySQL?
November 20, 2014 05:52AM
After installing mysql, mysql-server (5.5.40-0+wheezy1) it breaks apt-get. Apt-get just hangs, for example during apt-get update, it hangs on Reading package lists... 0%. Already tried 

apt-get clean
apt-get autoremove
apt-get autoclean
dpkg --clear-avail
rm /var/lib/apt/lists/* --force
dpkg --configure -a
apt-get update
cat /etc/apt/sources.list
deb http://ftp.us.debian.org/debian wheezy main
deb http://security.debian.org/ wheezy/updates main contrib non-free

Is any of you were able to install Wheezy mysql and not having problems with apt-get?



Edited 3 time(s). Last edit at 11/20/2014 10:04PM by Almaz.
Reply Quote
Almaz
Re: How to install MySQL?
November 20, 2014 10:06PM
Just installed a fresh rootfs 3.16 tld 2. Tried to install mysql-server and here is the log. Once I installed mysql-server on a fresh rootfs it broke the system. Any ideas? 

Nov 20 21:59:32 debian authpriv.info groupadd[2704]: group added to /etc/group: name=mysql, GID=108
Nov 20 21:59:32 debian authpriv.info groupadd[2704]: group added to /etc/gshadow: name=mysql
Nov 20 21:59:32 debian authpriv.info groupadd[2704]: new group: name=mysql, GID=108
Nov 20 21:59:33 debian authpriv.info useradd[2710]: new user: name=mysql, UID=106, GID=108, home=/nonexistent, shell=/bin/false
Nov 20 21:59:33 debian authpriv.info chage[2715]: changed password expiry for mysql
Nov 20 21:59:33 debian authpriv.info chfn[2718]: changed user 'mysql' information
Nov 20 21:59:43 debian daemon.err mysqld_safe[3079]: 141120 21:59:43 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:44 debian daemon.err mysqld_safe[3079]: 141120 21:59:44 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: 
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: To do so, start the server, then issue the following commands:
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: 
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: /usr/bin/mysqladmin -u root password 'new-password'
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: /usr/bin/mysqladmin -u root -h debian password 'new-password'
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: 
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: Alternatively you can run:
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: /usr/bin/mysql_secure_installation
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: 
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: which will also give you the option of removing the test
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: databases and anonymous user created by default.  This is
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: strongly recommended for production servers.
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: 
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: See the manual for more instructions.
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: 
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: Please report any problems at http://bugs.mysql.com/
Nov 20 21:59:45 debian daemon.err mysqld_safe[3079]: 
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 [Note] Plugin 'FEDERATED' is disabled.
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 InnoDB: The InnoDB memory heap is disabled
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 InnoDB: Compressed tables use zlib 1.2.7
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 InnoDB: Using Linux native AIO
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 InnoDB: Initializing buffer pool, size = 128.0M
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45 InnoDB: Completed initialization of buffer pool
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: InnoDB: The first specified data file ./ibdata1 did not exist:
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: InnoDB: a new database to be created!
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45  InnoDB: Setting file ./ibdata1 size to 10 MB
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: InnoDB: Database physically writes the file full: wait...
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: 141120 21:59:45  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Nov 20 21:59:45 debian daemon.err mysqld_safe[3123]: InnoDB: Database physically writes the file full: wait...
Nov 20 21:59:46 debian daemon.err mysqld_safe[3123]: 141120 21:59:46  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Nov 20 21:59:46 debian daemon.err mysqld_safe[3123]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Nov 20 21:59:46 debian daemon.err mysqld_safe[3123]: InnoDB: Database physically writes the file full: wait...
Nov 20 21:59:46 debian daemon.err mysqld_safe[3123]: InnoDB: Doublewrite buffer not found: creating new
Nov 20 21:59:46 debian daemon.err mysqld_safe[3123]: InnoDB: Doublewrite buffer created
Nov 20 21:59:47 debian daemon.err mysqld_safe[3123]: InnoDB: 127 rollback segment(s) active.
Nov 20 21:59:47 debian daemon.err mysqld_safe[3123]: InnoDB: Creating foreign key constraint system tables
Nov 20 21:59:47 debian daemon.err mysqld_safe[3123]: InnoDB: Foreign key constraint system tables created
Nov 20 21:59:47 debian daemon.err mysqld_safe[3123]: 141120 21:59:47  InnoDB: Waiting for the background threads to start
Nov 20 21:59:48 debian daemon.err mysqld_safe[3123]: 141120 21:59:48 InnoDB: 5.5.40 started; log sequence number 0
Nov 20 21:59:48 debian daemon.err mysqld_safe[3123]: 141120 21:59:48  InnoDB: Starting shutdown...
Nov 20 21:59:49 debian daemon.err mysqld_safe[3123]: 141120 21:59:49  InnoDB: Shutdown completed; log sequence number 1595675
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 [Note] Plugin 'FEDERATED' is disabled.
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 InnoDB: The InnoDB memory heap is disabled
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 InnoDB: Compressed tables use zlib 1.2.7
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 InnoDB: Using Linux native AIO
Nov 20 21:59:51 debian daemon.err mysqld_safe[3166]: 141120 21:59:51 InnoDB: Initializing buffer pool, size = 128.0M
Nov 20 21:59:52 debian daemon.err mysqld_safe[3166]: 141120 21:59:52 InnoDB: Completed initialization of buffer pool
Nov 20 21:59:52 debian daemon.err mysqld_safe[3166]: 141120 21:59:52 InnoDB: highest supported file format is Barracuda.
Nov 20 21:59:52 debian daemon.err mysqld_safe[3166]: 141120 21:59:52  InnoDB: Waiting for the background threads to start
Nov 20 21:59:53 debian daemon.err mysqld_safe[3166]: 141120 21:59:53 InnoDB: 5.5.40 started; log sequence number 1595675
Nov 20 21:59:53 debian daemon.err mysqld_safe[3166]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER S
Nov 20 21:59:53 debian daemon.err mysqld_safe[3166]: 141120 21:59:53 [ERROR] Aborting
Nov 20 21:59:53 debian daemon.err mysqld_safe[3166]: 
Nov 20 21:59:53 debian daemon.err mysqld_safe[3166]: 141120 21:59:53  InnoDB: Starting shutdown...
Nov 20 21:59:54 debian daemon.err mysqld_safe[3166]: 141120 21:59:54  InnoDB: Shutdown completed; log sequence number 1595675
Nov 20 21:59:54 debian daemon.err mysqld_safe[3166]: 141120 21:59:54 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 20 21:59:54 debian daemon.err mysqld_safe[3166]: 
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 [Note] Plugin 'FEDERATED' is disabled.
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 InnoDB: The InnoDB memory heap is disabled
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 InnoDB: Compressed tables use zlib 1.2.7
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 InnoDB: Using Linux native AIO
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 InnoDB: Initializing buffer pool, size = 128.0M
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 InnoDB: Completed initialization of buffer pool
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54 InnoDB: highest supported file format is Barracuda.
Nov 20 21:59:54 debian daemon.err mysqld_safe[3187]: 141120 21:59:54  InnoDB: Waiting for the background threads to start
Nov 20 21:59:55 debian daemon.err mysqld_safe[3187]: 141120 21:59:55 InnoDB: 5.5.40 started; log sequence number 1595675
Nov 20 21:59:55 debian daemon.err mysqld_safe[3187]: 141120 21:59:55  InnoDB: Starting shutdown...
Nov 20 21:59:56 debian daemon.err mysqld_safe[3187]: 141120 21:59:56  InnoDB: Shutdown completed; log sequence number 1595675
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 [Note] Plugin 'FEDERATED' is disabled.
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 InnoDB: The InnoDB memory heap is disabled
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 InnoDB: Compressed tables use zlib 1.2.7
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 InnoDB: Using Linux native AIO
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 InnoDB: Initializing buffer pool, size = 128.0M
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 InnoDB: Completed initialization of buffer pool
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56 InnoDB: highest supported file format is Barracuda.
Nov 20 21:59:56 debian daemon.err mysqld_safe[3208]: 141120 21:59:56  InnoDB: Waiting for the background threads to start
Nov 20 21:59:57 debian daemon.err mysqld_safe[3208]: 141120 21:59:57 InnoDB: 5.5.40 started; log sequence number 1595675
Nov 20 21:59:57 debian daemon.err mysqld_safe[3208]: ERROR: 1050  Table 'plugin' already exists
Nov 20 21:59:57 debian daemon.err mysqld_safe[3208]: 141120 21:59:57 [ERROR] Aborting
Nov 20 21:59:57 debian daemon.err mysqld_safe[3208]: 
Nov 20 21:59:57 debian daemon.err mysqld_safe[3208]: 141120 21:59:57  InnoDB: Starting shutdown...
Nov 20 21:59:58 debian daemon.err mysqld_safe[3208]: 141120 21:59:58  InnoDB: Shutdown completed; log sequence number 1595675
Nov 20 21:59:58 debian daemon.err mysqld_safe[3208]: 141120 21:59:58 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 20 21:59:58 debian daemon.err mysqld_safe[3208]: 
Nov 20 22:00:01 debian daemon.notice mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 [Note] Plugin 'FEDERATED' is disabled.
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 InnoDB: The InnoDB memory heap is disabled
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 InnoDB: Compressed tables use zlib 1.2.7
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 InnoDB: Using Linux native AIO
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 InnoDB: Initializing buffer pool, size = 128.0M
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 InnoDB: Completed initialization of buffer pool
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01 InnoDB: highest supported file format is Barracuda.
Nov 20 22:00:01 debian daemon.err mysqld: 141120 22:00:01  InnoDB: Waiting for the background threads to start
Nov 20 22:00:02 debian daemon.err mysqld: 141120 22:00:02 InnoDB: 5.5.40 started; log sequence number 1595675
Nov 20 22:00:02 debian daemon.err mysqld: 141120 22:00:02 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Nov 20 22:00:02 debian daemon.err mysqld: 141120 22:00:02 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
Nov 20 22:00:02 debian daemon.err mysqld: 141120 22:00:02 [Note] Server socket created on IP: '127.0.0.1'.
Nov 20 22:00:02 debian daemon.err mysqld: 141120 22:00:02 [Note] Event Scheduler: Loaded 0 events
Nov 20 22:00:02 debian daemon.err mysqld: 141120 22:00:02 [Note] /usr/sbin/mysqld: ready for connections.
Nov 20 22:00:02 debian daemon.err mysqld: Version: '5.5.40-0+wheezy1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Nov 20 22:00:03 debian daemon.info /etc/mysql/debian-start[3697]: Upgrading MySQL tables if necessary.
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: Status information:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: Current dir: /var/lib/mysql/
Nov 20 22:00:04 debian daemon.err mysqld: Running threads: 1  Stack size: 196608
Nov 20 22:00:04 debian daemon.err mysqld: Current locks:
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b30a08:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b2eb20:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b2cce8:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b2ae40:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b293d8:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b28624:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b1b900:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b16bc0:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b14a40:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b11898:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b0ed10:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b0c5c8:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b09ad0:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8b08164:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8afdef8:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8aef940:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8ac0398:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8ab65f0:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8a9d300:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8aaa048:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8a983a0:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8a93c80:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8a8e810:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb8a867c8:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b508:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b7c4:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b828:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b88c:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b56c:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b5d0:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b4a4:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b3dc:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b440:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b8f0:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b634:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b760:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b6fc:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b698:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b2b0:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b314:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: lock: 0xb707b378:
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: Key caches:
Nov 20 22:00:04 debian daemon.err mysqld: default
Nov 20 22:00:04 debian daemon.err mysqld: Buffer_size:      16777216
Nov 20 22:00:04 debian daemon.err mysqld: Block_size:           1024
Nov 20 22:00:04 debian daemon.err mysqld: Division_limit:        100
Nov 20 22:00:04 debian daemon.err mysqld: Age_limit:             300
Nov 20 22:00:04 debian daemon.err mysqld: blocks used:             0
Nov 20 22:00:04 debian daemon.err mysqld: not flushed:             0
Nov 20 22:00:04 debian daemon.err mysqld: w_requests:              0
Nov 20 22:00:04 debian daemon.err mysqld: writes:                  0
Nov 20 22:00:04 debian daemon.err mysqld: r_requests:              0
Nov 20 22:00:04 debian daemon.err mysqld: reads:                   0
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: handler status:
Nov 20 22:00:04 debian daemon.err mysqld: read_key:            2
Nov 20 22:00:04 debian daemon.err mysqld: read_next:           0
Nov 20 22:00:04 debian daemon.err mysqld: read_rnd             0
Nov 20 22:00:04 debian daemon.err mysqld: read_first:          5
Nov 20 22:00:04 debian daemon.err mysqld: write:              83
Nov 20 22:00:04 debian daemon.err mysqld: delete               0
Nov 20 22:00:04 debian daemon.err mysqld: update:              0
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: Table status:
Nov 20 22:00:04 debian daemon.err mysqld: Opened tables:         83
Nov 20 22:00:04 debian daemon.err mysqld: Open tables:           24
Nov 20 22:00:04 debian daemon.err mysqld: Open files:            48
Nov 20 22:00:04 debian daemon.err mysqld: Open streams:           0
Nov 20 22:00:04 debian daemon.err mysqld: 
Nov 20 22:00:04 debian daemon.err mysqld: Alarm status:
Nov 20 22:00:04 debian daemon.err mysqld: Active alarms:   0
Nov 20 22:00:04 debian daemon.err mysqld: Max used alarms: 0
Nov 20 22:00:04 debian daemon.err mysqld: Next alarm time: 0
Nov 20 22:00:05 debian auth.info sshd[3650]: Accepted password for root from 192.168.3.2 port 3371 ssh2
Nov 20 22:00:05 debian authpriv.info sshd[3650]: pam_unix(sshd:session): session opened for user root by (uid=0)
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: Looking for 'mysql' as: /usr/bin/mysql
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.columns_priv                                 OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.db                                           OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.event                                        OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.func                                         OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.general_log                                  OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.help_category                                OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.help_keyword                                 OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.help_relation                                OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.help_topic                                   OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.host                                         OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.ndb_binlog_index                             OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.plugin                                       OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.proc                                         OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.procs_priv                                   OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.proxies_priv                                 OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.servers                                      OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.slow_log                                     OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.tables_priv                                  OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.time_zone                                    OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.time_zone_leap_second                        OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.time_zone_name                               OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.time_zone_transition                         OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.time_zone_transition_type                    OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: mysql.user                                         OK
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: Running 'mysql_fix_privilege_tables'...
Nov 20 22:01:09 debian daemon.warn /etc/mysql/debian-start[3701]: OK
Nov 20 22:01:09 debian daemon.info /etc/mysql/debian-start[3762]: Checking for insecure root accounts.
Nov 20 22:01:09 debian daemon.info /etc/mysql/debian-start[3767]: Triggering myisam-recover for all MyISAM tables



Edited 1 time(s). Last edit at 11/20/2014 10:19PM by Almaz.
Reply Quote
Gravelrash
Re: How to install MySQL?
November 25, 2014 03:02AM
Have you tried installing it from the mysql repo instead?
Reply Quote
Almaz
Re: How to install MySQL?
November 25, 2014 03:39AM
I tried both but for some reason apt-get just hangs after install. After using a fresh rootfs and immediate restart after Mysql install, it works fine. I just can't figure it out why apt-get hangs after installation.
Reply Quote
Gravelrash
Re: How to install MySQL?
November 25, 2014 03:46AM
I can't comment for 3.16 rootfs. But 3.14, my fs of choice works OK.

Have you tried a different rootfs. To rule out if its specific to the one you are using or to all fs releases?
Reply Quote
Almaz
Re: How to install MySQL?
November 25, 2014 04:49AM
Yep, I tried 3.14 as well. If you do a clean rootfs install with apt-get update && apt-get upgrade && apt-get -y install mysql-server then apt-get will crash. Once you restart Debian then it'll be ok again.
Reply Quote
Gravelrash
Re: How to install MySQL?
November 25, 2014 07:05AM
my guess is its simply running out of resources?

apart from that im stumped!
Reply Quote
bodhi
Re: How to install MySQL?
November 25, 2014 07:51PM
Almaz Wrote:
-------------------------------------------------------
> Yep, I tried 3.14 as well. If you do a clean
> rootfs install with apt-get update && apt-get
> upgrade && apt-get -y install mysql-server then
> apt-get will crash. Once you restart Debian then
> it'll be ok again.

I'm not using mysql, but will try to repeat your problem to see if I can with 3.17.

-bodhi
===========================
Forum Wiki
bodhi's corner (buy bodhi a beer)
Reply Quote
Almaz
Re: How to install MySQL?
November 25, 2014 07:53PM
After you install mysql, try apt-get update and that's where it gets stuck but should work after reboot.
Reply Quote
bodhi
Re: How to install MySQL?
November 26, 2014 12:03AM
Almaz,

Yes, on rootfs 3.17, apt-get update did get stuck there at "Reading package lists... 0%".

But the system is not hang. I have a different ssh connection, and everything else seems normal. No high CPU or anything peculiar. Apt-get update just not taking any CPU or doing anything, perhaps waiting for some event that never occured. After reboot, apt-get update is stuck again, but I can Control-C to abort it.

-bodhi
===========================
Forum Wiki
bodhi's corner (buy bodhi a beer)
Reply Quote
Almaz
Re: How to install MySQL?
November 26, 2014 12:08AM
That's exactly what I had at first, apt-get update were stuck after reboot. For some reason if you install MySQL and right after install you reboot then run apt-get check && apt-get update then everything is working properly. Took me 2 days of testing or maybe even 3 :) I even recompiled from debian source and the latest 6.20 source, I ended up exactly with the same problem. After all, everything is working if you follow my steps.
Reply Quote
bodhi
Re: How to install MySQL?
November 26, 2014 01:55AM
> For some reason if you
> install MySQL and right after install you reboot
> then run apt-get check && apt-get update then
> everything is working properly.

Don't know if I'll ever reinstall mysql on my plugs, but it's good to know the workaround!

-bodhi
===========================
Forum Wiki
bodhi's corner (buy bodhi a beer)
Reply Quote
LeggoMyEggo
Re: How to install MySQL?
March 03, 2015 08:19AM
On 3.18.5 on my PP Pro I was having trouble getting Mysql 5.5 to start after loading it from apt-get. Turns out that it wouldn't start correctly because there was not enough RAM available - at least in Mysql's eyes. As soon as I created a 256MB swap file and turned it on, mysql would function normally.



Edited 2 time(s). Last edit at 03/03/2015 08:33AM by LeggoMyEggo.
Reply Quote
DonCharisma
Re: How to install MySQL?
March 04, 2015 10:30PM
@LeggoMyEggo - makes sense, MYSQL does like it's memory !

Don Charisma ... because anything is possible with Charisma

My blog - http://DonCharisma.org
Our commercial site - http://DonCharisma.com
Reply Quote
LeggoMyEggo
Re: How to install MySQL?
March 04, 2015 11:14PM
DonCharisma Wrote:
-------------------------------------------------------
> @LeggoMyEggo - makes sense, MYSQL does like it's
> memory !

I just wish there were a lightweight alternative for mysquirrel like lighttpd is to apache2. I've checked and mariadb is not available for armel. Bummer.
Reply Quote
bodhi
Re: How to install MySQL?
March 04, 2015 11:54PM
LeggoMyEggo Wrote:
-------------------------------------------------------
>
> I just wish there were a lightweight alternative
> for mysquirrel like lighttpd is to apache2. I've
> checked and mariadb is not available for armel.
> Bummer.

sqlite?

-bodhi
===========================
Forum Wiki
bodhi's corner (buy bodhi a beer)
Reply Quote
LeggoMyEggo
Re: How to install MySQL?
March 05, 2015 10:48AM
I don't think sqlite is completely command compatible with mysql but I could be wrong.
Reply Quote
Newer Topic Older Topic
Author:

Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: