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

Groups > linux.debian.user > #198204

Re: A tutorial for MySql installation

Show all headers | View raw

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.
> 

Back to linux.debian.user | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

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

csiph-web