Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #198184 > unrolled thread

Re: A tutorial for MySql installation

Back to article view | Back to linux.debian.user

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: A tutorial for MySql installation <tomas@tuxteam.de> - 2018-08-02 15:30 +0200
    Re: A tutorial for MySql installation Richard Owlett <rowlett@cloud85.net> - 2018-08-02 16:20 +0200
      Re: A tutorial for MySql installation <tomas@tuxteam.de> - 2018-08-02 17:10 +0200
        Re: A tutorial for MySql installation Richard Owlett <rowlett@cloud85.net> - 2018-08-02 19:50 +0200
      Re: A tutorial for MySql installation Richard Owlett <rowlett@cloud85.net> - 2018-08-02 17:10 +0200
        Re: A tutorial for MySql installation Nicholas Geovanis <nickgeovanis@gmail.com> - 2018-08-02 18:30 +0200
          Re: A tutorial for MySql installation Richard Owlett <rowlett@cloud85.net> - 2018-08-02 20:00 +0200
            Re: A tutorial for MySql installation "der.hans" <deb-user@LuftHans.com> - 2018-08-02 21:30 +0200
              Re: A tutorial for MySql installation Richard Owlett <rowlett@cloud85.net> - 2018-08-02 22:30 +0200

#198184 — Re: A tutorial for MySql installation

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Aug 02, 2018 at 08:20:08AM -0500, Richard Owlett wrote:
> Some time ago failed to install MariaDB. I hadn't realized it was
> tightly aimed at being on a network server.

The MariaDB server *is* conceptually a network server, as is the
MySQL server (but see below).

> It was pointed out that MySql would be more suitable.

I don't understand this statement...

>  I attempted to install it. It failed
> due to reasons I don't recall. I suspect that part of the problem
> was I was attempting to follow instructions aimed at an older
> release of MySql.
> 
> I am running Debian 9 (just did a system upgrade from 9.0).
> My hardware is a Thinkpad T510.
> I am the only user with physical access to the machine.
> I do *NOT* have any LAN software installed.

Note: Network and LAN are different things here. You don't
need a "running LAN" to have a (MariaDB, Mysql, PostgreSQL)
server running. But conceptually, they offer their services
at something which can be considered a network connection
(be it a local TCP/IP socket or a Unix domain socket).

> Is there a suitable tutorial for Debian 9 and whatever release of
> MySql is in the repository?

MySQL and MariaDB shouldn't be very different in this respect,
I guess...

Cheers
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iEQEARECAAYFAltjBtgACgkQBcgs9XrR2kYFJACYoJZWutiBM4npL6m5BzUt8xJW
CwCY1sWGm8WEDt1Lqn+q88S4Zu+MKQ==
=o4VZ
-----END PGP SIGNATURE-----

[toc] | [next] | [standalone]

#198187

On 08/02/2018 08:27 AM, tomas@tuxteam.de wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Thu, Aug 02, 2018 at 08:20:08AM -0500, Richard Owlett wrote:
>> Some time ago failed to install MariaDB. I hadn't realized it was
>> tightly aimed at being on a network server.
> 
> The MariaDB server *is* conceptually a network server, as is the
> MySQL server (but see below).
> 
>> It was pointed out that MySql would be more suitable.
> 
> I don't understand this statement...

Nor did I :/
During my reading before attempting to install MariaDB it was either an 
enhanced MySql or a renaming to avoid confusion with something that 
didn't meet how Debian defines FOSS.

> 
>>   I attempted to install it. It failed
>> due to reasons I don't recall. I suspect that part of the problem
>> was I was attempting to follow instructions aimed at an older
>> release of MySql.
>>
>> I am running Debian 9 (just did a system upgrade from 9.0).
>> My hardware is a Thinkpad T510.
>> I am the only user with physical access to the machine.
>> I do *NOT* have any LAN software installed.
> 
> Note: Network and LAN are different things here. You don't
> need a "running LAN" to have a (MariaDB, Mysql, PostgreSQL)
> server running. But conceptually, they offer their services
> at something which can be considered a network connection
> (be it a local TCP/IP socket or a Unix domain socket).

That may have been the source of one set of problems. I couldn't see a 
distinction in the documentation between references that strictly 
applied to a network server and what applied to the database server.

Is there something focused on that topic. If it's explanation doesn't 
solve my comprehension problems, at least it would be common ground for 
me ask further intelligent questions.

IIRC there were two different types of accounts (and associated 
passwords) to be set up. I messed up and was unable to untangle the mess.

> 
>> Is there a suitable tutorial for Debian 9 and whatever release of
>> MySql is in the repository?
> 
> MySQL and MariaDB shouldn't be very different in this respect,
> I guess...

<chuckle> I was aiming at MySql as I understood it shared the same 
end-user interface as MariaDB. I had originally aimed at MariaDB as a 
consultant for my church had created a web-page for us using WordPress 
which depends on MariaDB. My goal was to be able to do routine _content_ 
updates. Having worked for DEC in the 70's and heard war stories from 
senior field service supervisors, I was *NOT* about to apply any changes 
to a live website website without testing locally!

I don't have a strong preference for MySql over MariaDB. I need a 
tutorial valid for the version in the current repository.

Once burned, twice shy.

TIA

[toc] | [prev] | [next] | [standalone]

#198189

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Aug 02, 2018 at 09:10:12AM -0500, Richard Owlett wrote:
> On 08/02/2018 08:27 AM, tomas@tuxteam.de wrote:

[...]

> >>It was pointed out that MySql would be more suitable.
> >
> >I don't understand this statement...
> 
> Nor did I :/
> During my reading before attempting to install MariaDB it was either
> an enhanced MySql or a renaming to avoid confusion with something
> that didn't meet how Debian defines FOSS.

It was a reaction by some of the MySQL original developers (Monty
Widenius among others) to the fact that Oracle, by buying Sun's
leftovers, gained control of MySQL (MySQL had been sold to Sun before).

Obviously they didn't trust Oracle to be a good governor of a free
competition to their crown jewel, and they forked MySQL (which is
possible, because it was under a free license). See [1].

[...]

> >Note: Network and LAN are different things here. You don't
> >need a "running LAN" [...]

> That may have been the source of one set of problems. I couldn't see
> a distinction in the documentation between references that strictly
> applied to a network server and what applied to the database server.

There isn't actually a big difference for the server whether it is
serving local clients or clients over the network. Authentication
is stricter for network clients (you can limit them by IP address
and so on), but that should be all.

> Is there something focused on that topic. If it's explanation
> doesn't solve my comprehension problems, at least it would be common
> ground for me ask further intelligent questions.

The problem is that there are *lots* of docs (it is a complex
topic, after all). You can start a long browsing excursion here

  https://mariadb.org/learn/

> IIRC there were two different types of accounts (and associated
> passwords) to be set up. I messed up and was unable to untangle the
> mess.

Shit happens. For relational databases there's a fine-grained access
control system. Typically you start by setting up a "root" user
(perhaps there is one and you only need to set up its credentials),
who can create databases and grant rights to the more pedestrian
users.

> >>Is there a suitable tutorial for Debian 9 and whatever release of
> >>MySql is in the repository?
> >
> >MySQL and MariaDB shouldn't be very different in this respect,
> >I guess...
> 
> <chuckle> I was aiming at MySql as I understood it shared the same
> end-user interface as MariaDB [...]

They do share much more. MariaDB is aimed at being a "drop in"
replacement for MySQL for those who want to keep Oracle at some
distance.

> I don't have a strong preference for MySql over MariaDB. I need a
> tutorial valid for the version in the current repository.

Pick one. I'd pick MariaDB, but hey. I'm a bit wary of BigCorps.

> Once burned, twice shy.

Yes, more or less.

Cheers
- -- t
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iEYEARECAAYFAltjHm8ACgkQBcgs9XrR2kbWQwCfUqllC9MTdXVEajYhnR2wKedN
MRkAn0JcPyDuYkV/FtFoQO5qPKU3aeo4
=x3Xl
-----END PGP SIGNATURE-----

[toc] | [prev] | [next] | [standalone]

#198198

On 08/02/2018 10:08 AM, tomas@tuxteam.de wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Thu, Aug 02, 2018 at 09:10:12AM -0500, Richard Owlett wrote:
>> On 08/02/2018 08:27 AM, tomas@tuxteam.de wrote:
> 
> [...]
> 
>>>> It was pointed out that MySql would be more suitable.
>>>
>>> I don't understand this statement...
>>
>> Nor did I :/
>> During my reading before attempting to install MariaDB it was either
>> an enhanced MySql or a renaming to avoid confusion with something
>> that didn't meet how Debian defines FOSS.
> 
> It was a reaction by some of the MySQL original developers (Monty
> Widenius among others) to the fact that Oracle, by buying Sun's
> leftovers, gained control of MySQL (MySQL had been sold to Sun before).
> 
> Obviously they didn't trust Oracle to be a good governor of a free
> competition to their crown jewel, and they forked MySQL (which is
> possible, because it was under a free license). See [1].
> 
> [...]
> 
>>> Note: Network and LAN are different things here. You don't
>>> need a "running LAN" [...]
> 
>> That may have been the source of one set of problems. I couldn't see
>> a distinction in the documentation between references that strictly
>> applied to a network server and what applied to the database server.
> 
> There isn't actually a big difference for the server whether it is
> serving local clients or clients over the network. Authentication
> is stricter for network clients (you can limit them by IP address
> and so on), but that should be all.
> 
>> Is there something focused on that topic. If it's explanation
>> doesn't solve my comprehension problems, at least it would be common
>> ground for me ask further intelligent questions.
> 
> The problem is that there are *lots* of docs (it is a complex
> topic, after all). You can start a long browsing excursion here
> 
>    https://mariadb.org/learn/


My reading assignment for a long weekend that will be too hot outdoors.

Thanks.

[toc] | [prev] | [next] | [standalone]

#198190

On 08/02/2018 09:10 AM, Richard Owlett wrote:
> On 08/02/2018 08:27 AM, tomas@tuxteam.de wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On Thu, Aug 02, 2018 at 08:20:08AM -0500, Richard Owlett wrote:
>>> Some time ago failed to install MariaDB. I hadn't realized it was
>>> tightly aimed at being on a network server.
>>
>> The MariaDB server *is* conceptually a network server, as is the
>> MySQL server (but see below).
>>
>>> It was pointed out that MySql would be more suitable.
>>
>> I don't understand this statement...
> 
> Nor did I :/
> During my reading before attempting to install MariaDB it was either an 
> enhanced MySql or a renaming to avoid confusion with something that 
> didn't meet how Debian defines FOSS.
> 
>>
>>>   I attempted to install it. It failed
>>> due to reasons I don't recall. I suspect that part of the problem
>>> was I was attempting to follow instructions aimed at an older
>>> release of MySql.
>>>
>>> I am running Debian 9 (just did a system upgrade from 9.0).
>>> My hardware is a Thinkpad T510.
>>> I am the only user with physical access to the machine.
>>> I do *NOT* have any LAN software installed.
>>
>> Note: Network and LAN are different things here. You don't
>> need a "running LAN" to have a (MariaDB, Mysql, PostgreSQL)
>> server running. But conceptually, they offer their services
>> at something which can be considered a network connection
>> (be it a local TCP/IP socket or a Unix domain socket).
> 
> That may have been the source of one set of problems. I couldn't see a 
> distinction in the documentation between references that strictly 
> applied to a network server and what applied to the database server.
> 
> Is there something focused on that topic. If it's explanation doesn't 
> solve my comprehension problems, at least it would be common ground for 
> me ask further intelligent questions.
> 
> IIRC there were two different types of accounts (and associated 
> passwords) to be set up. I messed up and was unable to untangle the mess.
> 
>>
>>> Is there a suitable tutorial for Debian 9 and whatever release of
>>> MySql is in the repository?
>>
>> MySQL and MariaDB shouldn't be very different in this respect,
>> I guess...
> 
> <chuckle> I was aiming at MySql as I understood it shared the same 
> end-user interface as MariaDB. I had originally aimed at MariaDB as a 
> consultant for my church had created a web-page for us using WordPress 
> which depends on MariaDB. My goal was to be able to do routine _content_ 
> updates. Having worked for DEC in the 70's and heard war stories from 
> senior field service supervisors, I was *NOT* about to apply any changes 
> to a live website website without testing locally!
> 
> I don't have a strong preference for MySql over MariaDB. I need a 
> tutorial valid for the version in the current repository.
> 
> Once burned, twice shy.
> 
> TIA
> 

I now know that MariaDB 10.1 is what I should install and is the 
preferred release in the repository.

I went to the MariaDB homepage and followed links to 
[https://mariadb.com/kb/en/library/installing-mariadb-deb-files/].

It tries to be too many things for too many people
Along my convoluted path I came across a suggestion to use Synaptic and 
"just follow the prompts"(sic).

I'd like to know what the prompts will be so I can have thought out 
responses available. Some of my previous problems may have been due to 
blindly following prompts I didn't understand.

As it is a GUI ( not the command line ) I will not be able to use 
"script" to log exactly what happens. Is some log that will have the 
equivalent information so that when I get in trouble there will be an 
audit trail?

[toc] | [prev] | [next] | [standalone]

#198194

On Thu, Aug 2, 2018 at 10:01 AM Richard Owlett <rowlett@cloud85.net> wrote:
>
> I went to the MariaDB homepage and followed links to
> [https://mariadb.com/kb/en/library/installing-mariadb-deb-files/].

You should instead be installing it from the usual debian-hosted
repositories, unless you have a known need for a specific release. The
usual repos normally have multiple releases of MariaDB/MySQL on them.

> It tries to be too many things for too many people

MariaDB/MySQL are today DBMS's of commercial depth and quality. That
wasn't always the case. One whole lot of Earth's commerce is riding on
them today. They are inherently complex and learning them takes time
and some background perhaps. Maybe Apache CouchDB would be better for
your purposes unless you expect scads of data.

[toc] | [prev] | [next] | [standalone]

#198199

On 08/02/2018 11:21 AM, Nicholas Geovanis wrote:
> On Thu, Aug 2, 2018 at 10:01 AM Richard Owlett <rowlett@cloud85.net> wrote:
>>
>> I went to the MariaDB homepage and followed links to
>> [https://mariadb.com/kb/en/library/installing-mariadb-deb-files/].
> 
> You should instead be installing it from the usual debian-hosted
> repositories,

You're preaching to the choir. I've already mentioned 3 times that I 
want what is in the repository ;}


> unless you have a known need for a specific release. The
> usual repos normally have multiple releases of MariaDB/MySQL on them.
> 
>> It tries to be too many things for too many people
> 
> MariaDB/MySQL are today DBMS's of commercial depth and quality.

I was referring to the specific web page mentioned.

> That
> wasn't always the case. One whole lot of Earth's commerce is riding on
> them today. They are inherently complex and learning them takes time
> and some background perhaps. Maybe Apache CouchDB would be better for
> your purposes unless you expect scads of data.

I already listed a specific requirement. It is a prerequisite of WordPress.

[toc] | [prev] | [next] | [standalone]

#198202

[Multipart message — attachments visible in raw view] — view raw

Am 02. Aug, 2018 schwätzte Richard Owlett so:

At the end you say this is for WordPress, that pre-answers some of the
questions I was going to bring up :).

Unless you have specialized needs it doesn't matter which of the MySQL
forks you use. WordPress only uses general MySQL functionality, so use
whatever's in the repo.

For debian there's now default-mysql-server which is a metapackage picking
up MariaDB.

The debian package will give you a sane install with MariaDB listening on
a socket and on localhost port 3306.

By default you can connect from a root shell by just typing "mysql".

Debian has some convenience stuff for upgrades and that moved from using
"debian-sys-maint˝ to using "root".

Read /usr/share/doc/mariadb-server-10.1/README.Debian.gz

You shouldn't need to become a database expert to setup a CMS. We can use
more database experts, so if that's your goal, then please do read all the
database docs :).

I did not realize that WordPress is packaged.

The wordpress package provides a convenience script for setting it up.

See /usr/share/doc/wordpress/README.Debian.gz

I just installed stretch and the following was setup with no questions to
me:

# check listening port to make sure something is on MySQL's port, 3306
# the -p option requires running as root
# ss -tlnp | grep 3306
LISTEN     0      80     127.0.0.1:3306                     *:*
users:(("mysqld",pid=7326,fd=17))

# check the listed process id, make sure it's mysqld
# ps auxw | grep 7326 | grep -v grep
mysql     7326  0.0  0.4 686096 70444 ?        Ssl  18:49   0:00
/usr/sbin/mysqld

# check which package provided mysqld
# dpkg -S /usr/sbin/mysqld 
mariadb-server-core-10.1: /usr/sbin/mysqld

Back to finding out why communication packets are misbehaving...

ciao,

der.hans

> On 08/02/2018 11:21 AM, Nicholas Geovanis wrote:
>> On Thu, Aug 2, 2018 at 10:01 AM Richard Owlett <rowlett@cloud85.net> wrote:
>>> 
>>> I went to the MariaDB homepage and followed links to
>>> [https://mariadb.com/kb/en/library/installing-mariadb-deb-files/].
>> 
>> You should instead be installing it from the usual debian-hosted
>> repositories,
>
> You're preaching to the choir. I've already mentioned 3 times that I want 
> what is in the repository ;}
>
>
>> unless you have a known need for a specific release. The
>> usual repos normally have multiple releases of MariaDB/MySQL on them.
>> 
>>> It tries to be too many things for too many people
>> 
>> MariaDB/MySQL are today DBMS's of commercial depth and quality.
>
> I was referring to the specific web page mentioned.
>
>> That
>> wasn't always the case. One whole lot of Earth's commerce is riding on
>> them today. They are inherently complex and learning them takes time
>> and some background perhaps. Maybe Apache CouchDB would be better for
>> your purposes unless you expect scads of data.
>
> I already listed a specific requirement. It is a prerequisite of WordPress.

-- 
#  https://www.LuftHans.com   https://www.PhxLinux.org
#  "The only thing that interferes with my learning is my education."
#   -- Albert Einstein

[toc] | [prev] | [next] | [standalone]

#198204

On 08/02/2018 02:14 PM, der.hans wrote:
> Am 02. Aug, 2018 schwätzte Richard Owlett so:
> 
> At the end you say this is for WordPress, that pre-answers some of the
> questions I was going to bring up :).

And the questions were?
It allow me to get a handle on where my assumptions differ from the rest 
of the world.

> 
> Unless you have specialized needs it doesn't matter which of the MySQL
> forks you use. WordPress only uses general MySQL functionality, so use
> whatever's in the repo.
> 
> For debian there's now default-mysql-server which is a metapackage picking
> up MariaDB.
> 
> The debian package will give you a sane install with MariaDB listening on
> a socket and on localhost port 3306.
> 
> By default you can connect from a root shell by just typing "mysql".
> 
> Debian has some convenience stuff for upgrades and that moved from using
> "debian-sys-maint˝ to using "root".
> 
> Read /usr/share/doc/mariadb-server-10.1/README.Debian.gz

That leads to linked links for multiple useful pages - haven't counted 
them all - yet ;}
Thank you.

> 
> You shouldn't need to become a database expert to setup a CMS. We can use
> more database experts, so if that's your goal, then please do read all the
> database docs :).

I doubt I'll become an expert.
However, elsewhere I've said:
> I've saved ~6 years of useful posts from this group. I've been trying to figure out how to organize it in order to create a QWSBFA rather than a FAQ. QWSBFA=="Questions Which Should Be Frequently Asked" ;/ 
This may become an additional set of entries.


> 
> I did not realize that WordPress is packaged.
> 
> The wordpress package provides a convenience script for setting it up.
> 
> See /usr/share/doc/wordpress/README.Debian.gz
> 
> I just installed stretch and the following was setup with no questions to
> me:
> 
> # check listening port to make sure something is on MySQL's port, 3306
> # the -p option requires running as root
> # ss -tlnp | grep 3306
> LISTEN     0      80     127.0.0.1:3306                     *:*
> users:(("mysqld",pid=7326,fd=17))
> 
> # check the listed process id, make sure it's mysqld
> # ps auxw | grep 7326 | grep -v grep
> mysql     7326  0.0  0.4 686096 70444 ?        Ssl  18:49   0:00
> /usr/sbin/mysqld
> 
> # check which package provided mysqld
> # dpkg -S /usr/sbin/mysqld mariadb-server-core-10.1: /usr/sbin/mysqld

Those give me some man pages to lookup.

> 
> Back to finding out why communication packets are misbehaving...
> 
> ciao,
> 
> der.hans
> 
>> On 08/02/2018 11:21 AM, Nicholas Geovanis wrote:
>>> On Thu, Aug 2, 2018 at 10:01 AM Richard Owlett <rowlett@cloud85.net> 
>>> wrote:
>>>>
>>>> I went to the MariaDB homepage and followed links to
>>>> [https://mariadb.com/kb/en/library/installing-mariadb-deb-files/].
>>>
>>> You should instead be installing it from the usual debian-hosted
>>> repositories,
>>
>> You're preaching to the choir. I've already mentioned 3 times that I 
>> want what is in the repository ;}
>>
>>
>>> unless you have a known need for a specific release. The
>>> usual repos normally have multiple releases of MariaDB/MySQL on them.
>>>
>>>> It tries to be too many things for too many people
>>>
>>> MariaDB/MySQL are today DBMS's of commercial depth and quality.
>>
>> I was referring to the specific web page mentioned.
>>
>>> That
>>> wasn't always the case. One whole lot of Earth's commerce is riding on
>>> them today. They are inherently complex and learning them takes time
>>> and some background perhaps. Maybe Apache CouchDB would be better for
>>> your purposes unless you expect scads of data.
>>
>> I already listed a specific requirement. It is a prerequisite of 
>> WordPress.
> 

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web