* Where is mysql/administration command?
@ 2019-02-18 1:00 Yoshinori Arai
2019-02-18 1:11 ` Tobias Geerinckx-Rice
0 siblings, 1 reply; 8+ messages in thread
From: Yoshinori Arai @ 2019-02-18 1:00 UTC (permalink / raw)
To: help-guix
Hello,
I'm developping my site with httpd, php and mysql.
In my forerign distoro which is LFS, it is easy to setup the
development environment with XAMPP.
I have done system reconfigure to add httpd, mysql service to try to
setup same environment in GuixSD.
Mysql control commands is not in system profile but I can find these
commands in
/gnu/store/ni9waj5cyl94akwmzbrynfscy4k2igw7-mariadb-10.1.37/bin.
Is it correct way?
Why is not mysql commands in system profile?
Thank you.
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: Where is mysql/administration command?
2019-02-18 1:00 Where is mysql/administration command? Yoshinori Arai
@ 2019-02-18 1:11 ` Tobias Geerinckx-Rice
2019-02-18 3:05 ` Yoshinori Arai
0 siblings, 1 reply; 8+ messages in thread
From: Tobias Geerinckx-Rice @ 2019-02-18 1:11 UTC (permalink / raw)
To: Yoshinori Arai; +Cc: help-guix
Hullo,
Yoshinori Arai wrote:
> I have done system reconfigure to add httpd, mysql service to
> try to
> setup same environment in GuixSD.
[…]
> Why is not mysql commands in system profile?
Your operating-system's ‘packages’ field is probably missing
‘mariadb’. Services don't install packages to your system
profile.
Kind regards,
T G-R
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: Where is mysql/administration command?
2019-02-18 1:11 ` Tobias Geerinckx-Rice
@ 2019-02-18 3:05 ` Yoshinori Arai
2019-02-18 4:23 ` znavko
0 siblings, 1 reply; 8+ messages in thread
From: Yoshinori Arai @ 2019-02-18 3:05 UTC (permalink / raw)
To: Tobias Geerinckx-Rice; +Cc: help-guix
On Mon, Feb 18, 2019 at 02:11:28AM +0100, Tobias Geerinckx-Rice wrote:
> Hullo,
>
> Yoshinori Arai wrote:
> > I have done system reconfigure to add httpd, mysql service to try to
> > setup same environment in GuixSD.
>
> […]
>
> > Why is not mysql commands in system profile?
>
> Your operating-system's ‘packages’ field is probably missing ‘mariadb’.
> Services don't install packages to your system profile.
>
> Kind regards,
>
> T G-R
Hello,
Thank you for your rapid reply.
Is to use mysql needed both of mariaDB service and mysql service?
But I think the definition of mariaDB service is missing.
Do you mean to need mariaDB package or mysql package in system
configuration?
Thank you.
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: Where is mysql/administration command?
2019-02-18 3:05 ` Yoshinori Arai
@ 2019-02-18 4:23 ` znavko
2019-02-18 7:17 ` Yoshinori Arai
2019-02-18 14:41 ` Tobias Geerinckx-Rice
0 siblings, 2 replies; 8+ messages in thread
From: znavko @ 2019-02-18 4:23 UTC (permalink / raw)
To: Yoshinori Arai; +Cc: Tobias Geerinckx-Rice, help-guix
[-- Attachment #1: Type: text/plain, Size: 1316 bytes --]
Hello! Your nice question is quite reasonable.
To use mysql/administration commands on GuixSD need to have both:
mysql service
mysql package
When you've reconfigured your system adding mysql service to your config file you can either install mysql for root user with `# guix package -i mysql` or add mysql package system-wide (for all users) in '(packages ...)' section in your system config.
The same for postgresql. I used it the same way.
Hope you enjoy GuixSD!
Feb 18, 2019, 3:05 AM by kumagusu08@gmail.com:
> On Mon, Feb 18, 2019 at 02:11:28AM +0100, Tobias Geerinckx-Rice wrote:
>
>> Hullo,
>>
>> Yoshinori Arai wrote:
>> > I have done system reconfigure to add httpd, mysql service to try to
>> > setup same environment in GuixSD.
>>
>> […]
>>
>> > Why is not mysql commands in system profile?
>>
>> Your operating-system's ‘packages’ field is probably missing ‘mariadb’.
>> Services don't install packages to your system profile.
>>
>> Kind regards,
>>
>> T G-R
>>
>
> Hello,
>
> Thank you for your rapid reply.
>
> Is to use mysql needed both of mariaDB service and mysql service?
> But I think the definition of mariaDB service is missing.
> Do you mean to need mariaDB package or mysql package in system
> configuration?
>
> Thank you.
>
[-- Attachment #2: Type: text/html, Size: 3373 bytes --]
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: Where is mysql/administration command?
2019-02-18 4:23 ` znavko
@ 2019-02-18 7:17 ` Yoshinori Arai
2019-02-18 14:41 ` Tobias Geerinckx-Rice
1 sibling, 0 replies; 8+ messages in thread
From: Yoshinori Arai @ 2019-02-18 7:17 UTC (permalink / raw)
To: znavko; +Cc: Tobias Geerinckx-Rice, help-guix
Hello, I got. Thank you.
On Mon, Feb 18, 2019 at 05:23:31AM +0100, znavko@tutanota.com wrote:
>
> Hello! Your nice question is quite reasonable.
>
> To use mysql/administration commands on GuixSD need to have both:
> mysql service
> mysql package
> When you've reconfigured your system adding mysql service to your config file you can either install mysql for root user with `# guix package -i mysql` or add mysql package system-wide (for all users) in '(packages ...)' section in your system config.
>
> The same for postgresql. I used it the same way.
>
> Hope you enjoy GuixSD!
>
>
> Feb 18, 2019, 3:05 AM by kumagusu08@gmail.com:
>
> > On Mon, Feb 18, 2019 at 02:11:28AM +0100, Tobias Geerinckx-Rice wrote:
> >
> >> Hullo,
> >>
> >> Yoshinori Arai wrote:
> >> > I have done system reconfigure to add httpd, mysql service to try to
> >> > setup same environment in GuixSD.
> >>
> >> […]
> >>
> >> > Why is not mysql commands in system profile?
> >>
> >> Your operating-system's ‘packages’ field is probably missing ‘mariadb’.
> >> Services don't install packages to your system profile.
> >>
> >> Kind regards,
> >>
> >> T G-R
> >>
> >
> > Hello,
> >
> > Thank you for your rapid reply.
> >
> > Is to use mysql needed both of mariaDB service and mysql service?
> > But I think the definition of mariaDB service is missing.
> > Do you mean to need mariaDB package or mysql package in system
> > configuration?
> >
> > Thank you.
> >
>
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: Where is mysql/administration command?
2019-02-18 4:23 ` znavko
2019-02-18 7:17 ` Yoshinori Arai
@ 2019-02-18 14:41 ` Tobias Geerinckx-Rice
2019-02-18 19:16 ` znavko
1 sibling, 1 reply; 8+ messages in thread
From: Tobias Geerinckx-Rice @ 2019-02-18 14:41 UTC (permalink / raw)
To: znavko, Yoshinori Arai; +Cc: help-guix
Hullo,
znavko wrote:
> To use mysql/administration commands on GuixSD need to have
> both:
> mysql service
> mysql package
> When you've reconfigured your system adding mysql service to
> your config file you can either install mysql for root user
Just curious: why for root? Do you prefer su to sudo, or does it
make a real difference?
> with `# guix package -i mysql` or add mysql package system-wide
> (for all users) in '(packages ...)' section in your system
> config.
Hmm. It's important to note that Guix's (historically-named)
’mysql-service’ actually uses MariaDB by default:
;; From gnu/services/databases.scm:
(define-record-type* <mysql-configuration>
mysql-configuration make-mysql-configuration
mysql-configuration?
(mysql mysql-configuration-mysql (default mariadb))
(port mysql-configuration-port (default 3306)))
However, the ‘mysql’ package *is* actually MySQL, not MariaDB.
I don't know how compatible the two projects still are, but it's
probably much safer to install ‘mariadb’ instead.
$ guix package -i mariadb
> Hope you enjoy GuixSD!
+1000!
(Though s/SD/ System ;-)
Kind regards,
T G-R
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: Where is mysql/administration command?
2019-02-18 14:41 ` Tobias Geerinckx-Rice
@ 2019-02-18 19:16 ` znavko
2019-02-18 20:47 ` Tobias Geerinckx-Rice
0 siblings, 1 reply; 8+ messages in thread
From: znavko @ 2019-02-18 19:16 UTC (permalink / raw)
To: Tobias Geerinckx-Rice; +Cc: help-guix
[-- Attachment #1: Type: text/plain, Size: 1579 bytes --]
Hello, Tobias Geerinckx-Rice!
I use su, just for own commodity. The difference for me is that su does not need to type 'sudo' every time.
Some howtos mention meariadb package, the others type mysql.
What is the difference between mariadb and mysql?
Feb 18, 2019, 2:41 PM by somebody@not-sent-or-endorsed-by.tobias.gr:
> Hullo,
>
> znavko wrote:
>
>> To use mysql/administration commands on GuixSD need to have both:
>> mysql service
>> mysql package
>> When you've reconfigured your system adding mysql service to your config file you can either install mysql for root user
>>
>
> Just curious: why for root? Do you prefer su to sudo, or does it make a real difference?
>
>> with `# guix package -i mysql` or add mysql package system-wide (for all users) in '(packages ...)' section in your system config.
>>
>
> Hmm. It's important to note that Guix's (historically-named) ’mysql-service’ actually uses MariaDB by default:
>
> ;; From gnu/services/databases.scm:
> (define-record-type* <mysql-configuration>
> mysql-configuration make-mysql-configuration
> mysql-configuration?
> (mysql mysql-configuration-mysql (default mariadb))
> (port mysql-configuration-port (default 3306)))
>
> However, the ‘mysql’ package *is* actually MySQL, not MariaDB.
>
> I don't know how compatible the two projects still are, but it's probably much safer to install ‘mariadb’ instead.
>
> $ guix package -i mariadb
>
>> Hope you enjoy GuixSD!
>>
>
> +1000!
>
> (Though s/SD/ System ;-)
>
> Kind regards,
>
> T G-R
>
[-- Attachment #2: Type: text/html, Size: 3577 bytes --]
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: Where is mysql/administration command?
2019-02-18 19:16 ` znavko
@ 2019-02-18 20:47 ` Tobias Geerinckx-Rice
0 siblings, 0 replies; 8+ messages in thread
From: Tobias Geerinckx-Rice @ 2019-02-18 20:47 UTC (permalink / raw)
To: znavko; +Cc: Tobias Geerinckx-Rice, help-guix
Hullo, znavko!
znavko wrote:
> I use su, just for own commodity. The difference for me is that
> su does not need to type 'sudo' every time.
OK, thanks! I thought that perhaps mysql/mariadb was picky about
how they were run.
> Some howtos mention meariadb package, the others type mysql.
> What is the difference between mariadb and mysql?
Guix ships both, but prefers ‘mariadb’. I use PostgreSQL, so I'm
no expert here, but IIRC MariaDB was forked from MySQL when the
latter was taken over by Oracle.
MariaDB claims[1] to be compatible with MySQL, whatever that
means, but they also have things like their own storage engine
with claimed advantages[2] over MyISAM so they're going their own
way as well.
I don't see the point of using ‘mysql’ tools to administrate a
‘mariadb’ back-end. It seems like a huge risk with no benefits.
Kind regards,
T G-R
Sent from my GNU Emacs
[1]:
https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/
[2]: https://mariadb.com/kb/en/library/aria-faq/
^ permalink raw reply [flat|nested] 8+ messages in thread
end of thread, other threads:[~2019-02-18 20:47 UTC | newest]
Thread overview: 8+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2019-02-18 1:00 Where is mysql/administration command? Yoshinori Arai
2019-02-18 1:11 ` Tobias Geerinckx-Rice
2019-02-18 3:05 ` Yoshinori Arai
2019-02-18 4:23 ` znavko
2019-02-18 7:17 ` Yoshinori Arai
2019-02-18 14:41 ` Tobias Geerinckx-Rice
2019-02-18 19:16 ` znavko
2019-02-18 20:47 ` Tobias Geerinckx-Rice
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/guix.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.