Re: Doing a clean install with ATYPICAL constraints
On 05/11/2017 02:15 PM, Greg Wooledge wrote:
On Thu, May 11, 2017 at 08:12:29PM +0100, Joe wrote:
OK, it looks like I'm wrong, and the Debian packaging of mariadb is
*not* a drop-in replacement for mysql, at least from a clean
installation.
I was sort of under the impression that Debian had changed horses to
mariadb, and managed it with metafiles and transition packages, but it
appears that both my wheezy server and my sid workstation are still on
mysql. I'm using mariadb, but apparently only on my Win8 laptop.
I don't use MySQL or MariaDB myself, but a MySQL -> MariaDB transition
is listed as one of the stretch release goals, and "done", here:
https://lists.debian.org/debian-devel-announce/2017/04/msg00008.html
No claim to be bug free ;}
I the post's date significant. IIRC about that date something changed in
what Synaptic said was available. I believe a mysql meta-package was
deleted. But I'm relying *ONLY* on memory *NOT DOCUMENTED EVIDENCE*
I suspect there is a documentation problem.
Following the startup procedure outlined in
https://www.tecmint.com/install-mariadb-in-debian/
which joe mentioned, I got a lot further than previously.
Still using *ONLY* the *STRETCH* repository.
See transcript below :}
richard@stretch-2nd:~$ su
Password:
root@stretch-2nd:/home/richard# mariadb
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.1.22-MariaDB- Debian 9.0
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [(none)]> CREATE USER 'sam' IDENTIFIED BY 'sam123';
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> select user, host, authentication_string, password from
mysql.user;
+------+-----------+-----------------------+-------------------------------------------+
| user | host | authentication_string | password
|
+------+-----------+-----------------------+-------------------------------------------+
| root | localhost | |
*EAFDCF7DE7B8B5BA5CBA28FDD878420CF08E7764 |
| sam | % | |
*26F07D3B38B5FAC4BA063A5D76D2895C73319D78 |
+------+-----------+-----------------------+-------------------------------------------+
2 rows in set (0.00 sec)
MariaDB [mysql]> help version
Name: 'VERSION'
Description:
Syntax:
VERSION()
Returns a string that indicates the MySQL server version. The string
uses the utf8 character set. The value might have a suffix in addition
to the version number. See the description of the version system
variable in
https://mariadb.com/kb/en/server-system-variables#version.
URL: https://mariadb.com/kb/en/version/
Examples:
MariaDB> SELECT VERSION();
-> '5.5.29-standard'
MariaDB [mysql]> SELECT VERSION();
+------------------+
| VERSION() |
+------------------+
| 10.1.22-MariaDB- |
+------------------+
1 row in set (0.00 sec)
MariaDB [mysql]> \q
Bye
>>>>>>>>>>>>> A *SUCCESSFUL* login <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
root@stretch-2nd:/home/richard# mariadb -u sam -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.1.22-MariaDB- Debian 9.0
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [(none)]> \q
Bye
>>> A *_NOT_ SUCCESSFUL* login {intentionally bad password ;} <<<<<
root@stretch-2nd:/home/richard# mariadb -u sam -p
Enter password:
ERROR 1045 (28000): Access denied for user 'sam'@'localhost' (using
password: YES)
root@stretch-2nd:/home/richard#
I've some more tests to run.
Reply to: