Tentei migrar para o MariaDB e olha no que deu

Mroffspring
(usa Manjaro Linux)

Enviado em 22/11/2016 - 19:43h

Tentei migrar para o MariaDB segundo a wiki, quando dei o código com o seguinte resultado:

sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/

Installing MariaDB/MySQL system tables in '/var/lib/' ...

2016-11-22 18:42:18 140502002228736 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 6246 ...

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: The InnoDB memory heap is disabled

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Compressed tables use zlib 1.2.8

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Using Linux native AIO

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Using generic crc32 instructions

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Completed initialization of buffer pool

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Highest supported file format is Barracuda.

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: 128 rollback segment(s) are active.

2016-11-22 18:42:18 140502002228736 [Note] InnoDB: Waiting for purge to start

2016-11-22 18:42:18 140502002228736 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 1623751

2016-11-22 18:42:18 140501407753984 [Note] InnoDB: Dumping buffer pool(s) not yet started

OK

Filling help tables...

2016-11-22 18:42:21 140652498394624 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 6281 ...

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: The InnoDB memory heap is disabled

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Compressed tables use zlib 1.2.8

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Using Linux native AIO

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Using generic crc32 instructions

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Completed initialization of buffer pool

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Highest supported file format is Barracuda.

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: 128 rollback segment(s) are active.

2016-11-22 18:42:21 140652498394624 [Note] InnoDB: Waiting for purge to start

2016-11-22 18:42:22 140652498394624 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 1623761

2016-11-22 18:42:22 140651903575808 [Note] InnoDB: Dumping buffer pool(s) not yet started

OK

Creating OpenGIS required SP-s...

2016-11-22 18:42:25 139919051025920 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 6312 ...

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: The InnoDB memory heap is disabled

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Compressed tables use zlib 1.2.8

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Using Linux native AIO

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Using generic crc32 instructions

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Completed initialization of buffer pool

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Highest supported file format is Barracuda.

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: 128 rollback segment(s) are active.

2016-11-22 18:42:25 139919051025920 [Note] InnoDB: Waiting for purge to start

2016-11-22 18:42:25 139919051025920 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 1623771

2016-11-22 18:42:25 139918456121088 [Note] InnoDB: Dumping buffer pool(s) not yet started

OK



To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system



PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !

To do so, start the server, then issue the following commands:



'/usr/bin/mysqladmin' -u root password 'new-password'

'/usr/bin/mysqladmin' -u root -h mateusarch password 'new-password'



Alternatively you can run:

'/usr/bin/mysql_secure_installation'



which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.



See the MariaDB Knowledgebase at http://mariadb.com/kb or the

MySQL manual for more instructions.



You can start the MariaDB daemon with:

cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/'



You can test the MariaDB daemon with mysql-test-run.pl

cd '/usr/mysql-test' ; perl mysql-test-run.pl



Please report any problems at http://mariadb.org/jira">http://mariadb.org/jira



The latest information about MariaDB is available at http://mariadb.org/.

You can find additional information about the MySQL part at:

http://dev.mysql.com

Support MariaDB development by buying support/new features from MariaDB

Corporation Ab. You can contact us about this at sales@mariadb.com.

Alternatively consider joining our community based development effort:

http://mariadb.com/kb/en/contributing-to-the-mariadb-project/

 

Tentei seguir essa instrução aqui :

'/usr/bin/mysqladmin' -u root password 'new-password' 

Porém o resultado foi:

sudo /usr/bin/mysqladmin -u root password

/usr/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")'

Check that mysqld is running and that the socket: '/run/mysqld/mysqld.sock' exists!

 

Ajudem ai

julianoolenick
(usa Ubuntu)

Enviado em 22/11/2016 - 20:48h

Este erro pode ser porque o serviço do mariadb não esta ativo

service mariadb start

----------------------------------------------------------------------------------------
Juliano Olenick - Netguard - http://www.netguard.com.br

carloschoma
(usa Debian)

Enviado em 23/11/2016 - 09:24h

Olá!
Já deu o start no server? mysql.server start

Para fazer automático olhe:
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system