Stránka 2 z 3
Re: VPS - MySQL
Napsal: 12 dub 2019, 22:13
od vovicek
Při každém pokusu upravit config pomocí mc editoru dostanu toto hlášení:
Kód: Vybrat vše
E325: ATTENTION
Found a swap file by the name "/etc/mysql/mariadb.conf.d/.50-server.cnf.swp"
owned by: root dated: Fri Apr 12 19:40:21 2019
file name: /etc/mysql/mariadb.conf.d/50-server.cnf
modified: YES
user name: root host name: staff.zeddicraft.eu
process ID: 3222
While opening file "/etc/mysql/mariadb.conf.d/50-server.cnf"
dated: Wed Feb 6 05:53:10 2019
(1) Another program may be editing the same file. If this is the case,
be careful not to end up with two different instances of the same
file when making changes. Quit, or continue with caution.
(2) An edit session for this file crashed.
If this is the case, use ":recover" or "vim -r /etc/mysql/mariadb.conf.d/50-server.cnf"
to recover the changes (see ":help recovery").
If you did this already, delete the swap file "/etc/mysql/mariadb.conf.d/.50-server.cnf.swp"
to avoid this message.
Re: VPS - MySQL
Napsal: 12 dub 2019, 22:48
od Homi74
Božínku
a kdo Ti řek, že máš editovat tohle
tak že /etc/mysql/my.cnf
Re: VPS - MySQL
Napsal: 12 dub 2019, 22:50
od vovicek
Homi74 píše:Božínku
a kdo Ti řek, že máš editovat tohle
tak že /etc/mysql/my.cnf
Jenže v /etc/mysql/my.cnf nemám "bind-address: ***"
Re: VPS - MySQL
Napsal: 12 dub 2019, 23:00
od Homi74
tak to tam dopiš
bind-address = 0.0.0.0
edit: nebo tam máš jen
!includedir ?
Re: VPS - MySQL
Napsal: 12 dub 2019, 23:09
od vovicek
Homi74 píše:tak to tam dopiš
bind-address = 0.0.0.0
edit: nebo tam máš jen
!includedir ?
Tohle je obsah toho souboru.
Kód: Vybrat vše
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
Re: VPS - MySQL
Napsal: 12 dub 2019, 23:13
od Homi74
Kód: Vybrat vše
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
[mysqld]
bind-address = 0.0.0.0
Re: VPS - MySQL
Napsal: 12 dub 2019, 23:31
od vovicek
Znovu mi to vyhazuje chybu při pokusu o přepsání toho souboru, já mám přístup pouze ke čtení toho souboru..
Kód: Vybrat vše
E325: ATTENTION
Found a swap file by the name "/etc/mysql/.mariadb.cnf.swp"
owned by: root dated: Fri Apr 12 21:29:15 2019
file name: /etc/mysql/my.cnf
modified: YES
user name: root host name: staff.zeddicraft.eu
process ID: 4653 (still running)
While opening file "/etc/mysql/my.cnf"
dated: Wed Feb 6 05:53:10 2019
(1) Another program may be editing the same file. If this is the case,
be careful not to end up with two different instances of the same
file when making changes. Quit, or continue with caution.
(2) An edit session for this file crashed.
If this is the case, use ":recover" or "vim -r /etc/mysql/my.cnf"
to recover the changes (see ":help recovery").
If you did this already, delete the swap file "/etc/mysql/.mariadb.cnf.swp"
to avoid this message.
Re: VPS - MySQL
Napsal: 14 dub 2019, 13:52
od vovicek
Dokázal by mi prosím někdo nastavit MySQL na VPS? Klidně za to zaplatím.. Jen už nechci ztrácet čas čekáním na odpověď..
Re: VPS - MySQL
Napsal: 16 dub 2019, 16:18
od Homi74
Trpělivost růže přináší
Tak neztrácej čas čekáním a snaž se i něco naučit
nebo budeš stále čekat až to za tebe někdo udělá?
Re: VPS - MySQL
Napsal: 18 dub 2019, 09:51
od Mike8748
vovicek píše:Znovu mi to vyhazuje chybu při pokusu o přepsání toho souboru, já mám přístup pouze ke čtení toho souboru..
taková podstatná otázka.. když edituješ ten soubor, jsi přihlášen jako root (máš odpovídající práva) ?
pokud si přihlášen jen jako obyčejný uživatel tak je docela pochopitelné že ten soubor nemůžeš přepsat