[Babooco]

#mysql #programowanie #informatyka

Co tutaj jest źle??

# 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]




wywołanie:

pi@raspberrypi:~ $ mysql
error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 2
Fatal error in defaults handling. Program aborted

[ceie777]

..#

@Babooco: usuń ".."

[Rexikon]

@Babooco: masz kropkę w 2 linii

[Babooco]

@Rexikon: @ceie777: Po usunięciu kropek mam

pi@raspberrypi:~ $ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

Nie mam pliku w tej ścieżce, ale też nic nie kasowałem.

[Babooco]

Nie wiem co mam dodać jak tworzę ten plik

[Babooco]

@ceie777: @Rexikon: pi@raspberrypi:~ $ sudo mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

[Rexikon]

@Babooco: w configu ustawić musisz socketa https://dev.mysql.com/doc/refman/5.7/en/option-files.html

[Babooco]

@Rexikon: @ceie777:

Wpisałem tak i działa

[client]
port=3306
#socket=/tmp/mysql.sock

[mysqld]
port=3306
#socket=/tmp/mysql.sock
#keybuffersize=16M
#maxallowedpacket=8M

[mysqldump]
quick