wiki.server17.net

User Tools

Site Tools

Trace: • network
myhelp:sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
myhelp:sql [2024/07/30 10:35] – ulrichmyhelp:sql [2024/10/05 07:51] (current) – [mySQL / MariaDB] ulrich
Line 18: Line 18:
 CREATE USER 'benutzer'@'localhost' IDENTIFIED BY 'passwort'; CREATE USER 'benutzer'@'localhost' IDENTIFIED BY 'passwort';
 GRANT ALL PRIVILEGES ON meineDB . * TO 'benutzer'@'localhost'; GRANT ALL PRIVILEGES ON meineDB . * TO 'benutzer'@'localhost';
 +</code>
 +
 +Grant Access from remote IP (10.11.12.13)
 +<code>
 +GRANT ALL ON meineDB.* to 'benutzer'@'10.11.12.13' IDENTIFIED BY 'passwort' WITH GRANT OPTION;
 </code> </code>
  
myhelp/sql.1722335746.txt.gz · Last modified: by ulrich