Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > linux.debian.user > #180938
| From | Richard Owlett <rowlett@cloud85.net> |
|---|---|
| Newsgroups | linux.debian.user |
| Subject | Re: Doing a clean install with ATYPICAL constraints |
| Date | 2017-05-11 22:20 +0200 |
| Message-ID | <tG2J3-2Bd-1@gated-at.bofh.it> (permalink) |
| References | <tG0xA-11Q-1@gated-at.bofh.it> <tG1MZ-1Xg-9@gated-at.bofh.it> <tG1MZ-1Xg-7@gated-at.bofh.it> |
| Organization | linux.* mail to news gateway |
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.
Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Doing a clean install with ATYPICAL constraints Richard Owlett <rowlett@cloud85.net> - 2017-05-11 20:00 +0200
Re: Doing a clean install with ATYPICAL constraints Greg Wooledge <wooledg@eeg.ccf.org> - 2017-05-11 21:20 +0200
Re: Doing a clean install with ATYPICAL constraints Richard Owlett <rowlett@cloud85.net> - 2017-05-11 22:20 +0200
Re: Doing a clean install with ATYPICAL constraints Joe <joe@jretrading.com> - 2017-05-11 21:20 +0200
A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Richard Owlett <rowlett@cloud85.net> - 2017-05-12 05:00 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Brian <ad44@cityscape.co.uk> - 2017-05-12 10:00 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Richard Owlett <rowlett@cloud85.net> - 2017-05-12 16:50 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] deloptes <deloptes@gmail.com> - 2017-05-12 19:50 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Richard Owlett <rowlett@cloud85.net> - 2017-05-12 21:50 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] <tomas@tuxteam.de> - 2017-05-12 23:20 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Richard Owlett <rowlett@cloud85.net> - 2017-05-13 14:40 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Brian <ad44@cityscape.co.uk> - 2017-05-13 14:50 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Richard Owlett <rowlett@cloud85.net> - 2017-05-13 16:30 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] songbird <songbird@anthive.com> - 2017-05-13 18:10 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] Richard Owlett <rowlett@cloud85.net> - 2017-05-13 19:30 +0200
Re: A regression bug comparing Stretch to Jessie -was [Re: Doing a clean install with ATYPICAL constraints] songbird <songbird@anthive.com> - 2017-05-13 21:30 +0200
csiph-web