59 lines
1.7 KiB
Plaintext
59 lines
1.7 KiB
Plaintext
CREATE DATABASE xtest;
|
|
CREATE USER 'user1'@'127.0.0.1' IDENTIFIED BY 'user1_pass';
|
|
CREATE USER 'user2'@'127.0.0.1' IDENTIFIED BY 'user2_pass';
|
|
GRANT SELECT ON xtest.* TO user1@'127.0.0.1';
|
|
GRANT SELECT ON xtest.* TO user2@'127.0.0.1';
|
|
|
|
############################################################
|
|
## Verify mysqlxtests variables at first connection
|
|
##
|
|
#
|
|
# Command line options must be unchange, on unauthenticated connection
|
|
# on every session or authenticated account
|
|
#
|
|
# Authenticating on existing connection
|
|
Login OK
|
|
# * SOCKET_ID must be the same as before
|
|
# * CLIENT_ID must have a expected value
|
|
#
|
|
# Command line options must be unchange, on authenticated connection
|
|
# on every session or authenticated account
|
|
#
|
|
# New connection:
|
|
connecting...
|
|
active session is now 'second_session'
|
|
#
|
|
# Command line options must be unchange, on second session
|
|
# on every session or authenticated account
|
|
# * SOCKET_ID must have a new value
|
|
# * CLIENT_ID must have a new value
|
|
ok
|
|
|
|
############################################################
|
|
## Verify mysqlxtests variables at second connection
|
|
##
|
|
#
|
|
# Command line options must be unchange, on unauthenticated connection
|
|
# on every session or authenticated account
|
|
#
|
|
# Authenticating on existing connection
|
|
Login OK
|
|
# * SOCKET_ID must be the same as before
|
|
# * CLIENT_ID must have a expected value
|
|
#
|
|
# Command line options must be unchange, on authenticated connection
|
|
# on every session or authenticated account
|
|
#
|
|
# New connection:
|
|
connecting...
|
|
active session is now 'second_session'
|
|
#
|
|
# Command line options must be unchange, on second session
|
|
# on every session or authenticated account
|
|
# * SOCKET_ID must have a new value
|
|
# * CLIENT_ID must have a new value
|
|
ok
|
|
DROP DATABASE xtest;
|
|
DROP USER 'user1'@'127.0.0.1';
|
|
DROP USER 'user2'@'127.0.0.1';
|