Re: [Maria-discuss] [question] password input length

2018-05-15 Thread daniel
On Sat, 12 May 2018 18:46:35 +0200 Michal Schorm wrote: Hello everyone, 1) I found out, that passwords longer than 79 characters aren't accepted via password prompt. Is that expected? Code seem to say yes: https://github.com/MariaDB/server/blob/10.3/client/mysql.cc#L1959 https://github.com

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 18:06 schrieb Reindl Harald: > Am 15.05.2018 um 17:53 schrieb Muhammad Bashir Al-Noimi: >> On 05/15/2018 01:34 PM, Reindl Harald wrote: >>> * that's all plaintext >>> * post it deirectly >>> * look in the errorlog >>> * post systemctl outputs (also for systemctl status) >>> >>> *

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 17:53 schrieb Muhammad Bashir Al-Noimi: > On 05/15/2018 01:34 PM, Reindl Harald wrote: >> Am 15.05.2018 um 12:22 schrieb Muhammad Bashir Al-Noimi: >>> On 05/15/2018 01:12 PM, Reindl Harald wrote: so it works and " error: 'Access denied for user 'root'@'localhost' (using

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 01:34 PM, Reindl Harald wrote: Am 15.05.2018 um 12:22 schrieb Muhammad Bashir Al-Noimi: On 05/15/2018 01:12 PM, Reindl Harald wrote: so it works and " error: 'Access denied for user 'root'@'localhost' (using passwor

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
and BTW the "--pid-file=/dev/null" has a damned good reason because you don't need to care about subfolders below /run to get re-created with corerct permissions at reboot while a restriucted user can't create folders and files there and run is tmpfs aka memory since mariadb is a single-process mu

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 12:22 schrieb Muhammad Bashir Al-Noimi: > On 05/15/2018 01:12 PM, Reindl Harald wrote: >> so it works and " error: 'Access denied for user 'root'@'localhost' >> (using password: YES)'" is what it is >> >> are you aware that 'root' on unix-socket (localhost) is not the same >> tha

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 01:12 PM, Reindl Harald wrote: so it works and " error: 'Access denied for user 'root'@'localhost' (using password: YES)'" is what it is are you aware that 'root' on unix-socket (localhost) is not the same than 'root' over TCP (127.0.0.1) beause you h

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 12:06 schrieb Muhammad Bashir Al-Noimi: > On 05/15/2018 12:09 PM, Kenneth Penza wrote: >> /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  >> -uroot -p version > I tried to call it with mariadb user instead of root so I get this result: > > # /opt/mariadb/b

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 12:09 PM, Kenneth Penza wrote: /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  -uroot -p version I tried to call it with mariadb user instead of root so I get this result: # /opt/mariadb/bin/m

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 12:52 PM, Reindl Harald wrote: in fact each tool has it's own config section in the defaults file while port is for TCP (127.0.0.1) and socket for socket-connections (localhost) [mysqld] socket = /var/lib/mysql/mysql-replication.sock port = 3307 [cli

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 11:49 schrieb Reindl Harald: > > > Am 15.05.2018 um 11:39 schrieb Muhammad Bashir Al-Noimi: >> # /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  >> -uroot -p shutdown >> Enter password: >> /opt/mariadb/bin/mysqladmin: connect to server at 'localhost' fail

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 11:39 schrieb Muhammad Bashir Al-Noimi: > # /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  > -uroot -p shutdown > Enter password: > /opt/mariadb/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (us

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
Thanks a lot Kenneth, On 05/15/2018 12:09 PM, Kenneth Penza wrote: Good morning Muhammad, I have checked and I am using your mariadb.service file. For some reason, mariadb is failing to start.  We need to determine

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Kenneth Penza
Good morning Muhammad, I have checked and I am using your mariadb.service file. For some reason, mariadb is failing to start. We need to determine if the issue is coming from systemd or something in MariaDB datadir. To start it without systemd, run: /opt/mariadb/bin/mysqld --defaults-file=/op

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/12/2018 11:56 PM, Kenneth Penza wrote: I have installed a new Ubuntu VM 16.04, installed MySQL 5.7 from Ubuntu repositories and MariaDB using the outline provided in the link https://ubuntuforums.org/showthread.php?t=2391680&p=137