Re: mysqld_multi

Am 31.05.2017 um 17:48 schrieb Matthew Black:
> # mysql -uroot -p --socket=/MySQLdb/cba/mysql.sock
> mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
> mysql> quit
> 
> I was simply seeking those three commands, but the reference manual did not provide a real-world example.

they don't behave anything different if you have a single server, 
mysqld_multi or just a dozen mysqld instances started directly with 
systemd and "Can anyone provide a simple example of how to edit 
/etc/my.cnf file and command line steps necessary for creating a new 
database running on, for example, port 3311" still is nosense besides a 
basic command like "create table database" where your problem was 
obviosuly connect to the instance at all

in my first response you got:
[harry@srv-rhsoft:~]$ mysql --help | grep port

well, find the socket option is similar

[harry@rh:~]$ mysql --help | grep socket
   -S, --socket=name   The socket file to use for connection.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql