MySQL einrichten

[noxx]

Moin

versuche gerade MySQL einzurichten, aber hier scheint was nicht zu stimmen,

komme aus der Konsole nicht raus:

pi@raspberrypi:/opt/iobroker $ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 63
Server version: 5.5.55-0+deb8u1 (Raspbian)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE USER 'iobroker‘@’%’ IDENTIFIED BY 'iobroker';
    '> GRANT ALL PRIVILEGES ON * . * TO 'iobroker'@'%';
    '> FLUSH PRIVILEGES;
    '> exit;
    '>

Bin hiernach vorgegangen

https://github.com/ioBroker/ioBroker.sql

` > MySQL:

You can install mysql on linux systems:

apt-get install mysql-server mysql-client

mysql -uroot -p

CREATE USER 'iobroker‘@’%’ IDENTIFIED BY 'iobroker';

GRANT ALL PRIVILEGES ON * . * TO 'iobroker'@'%';

FLUSH PRIVILEGES;

If required edit /etc/mysql/my.cnf to set bind to IP-Address for remote connect.

Warning: iobroker user is "admin". If required give limited rights to iobroker user. `
2880_1.png

[noxx]

beim schreiben des ersten Beitrags Fehler gefunden.

Der erste Befehl ist nicht sauber mit den Hochkommas

Damit gehts

CREATE USER 'iobroker'@'%' IDENTIFIED BY 'iobroker';