sujatha@sujatha:~/bug_repo/test-10.5/bld/mysql-test$ ../client/mysql_upgrade -S/home/sujatha/bug_repo/test-10.5/bld/mysql-test/var/tmp/mysqld.2.sock
|
Phase 1/7: Checking and upgrading mysql database
|
Processing databases
|
mysql
|
mysql.column_stats OK
|
mysql.columns_priv OK
|
mysql.db OK
|
mysql.event OK
|
mysql.func OK
|
mysql.global_priv OK
|
mysql.gtid_slave_pos OK
|
mysql.help_category OK
|
mysql.help_keyword OK
|
mysql.help_relation OK
|
mysql.help_topic OK
|
mysql.index_stats OK
|
mysql.innodb_index_stats OK
|
mysql.innodb_table_stats OK
|
mysql.plugin OK
|
mysql.proc OK
|
mysql.procs_priv OK
|
mysql.proxies_priv OK
|
mysql.roles_mapping OK
|
mysql.servers OK
|
mysql.table_stats OK
|
mysql.tables_priv OK
|
mysql.time_zone OK
|
mysql.time_zone_leap_second OK
|
mysql.time_zone_name OK
|
mysql.time_zone_transition OK
|
mysql.time_zone_transition_type OK
|
mysql.transaction_registry OK
|
Phase 2/7: Installing used storage engines... Skipped
|
Phase 3/7: Fixing views
|
mysql.user OK
|
Phase 4/7: Running 'mysql_fix_privilege_tables'
|
Phase 5/7: Fixing table and database names
|
Phase 6/7: Checking and upgrading tables
|
Processing databases
|
information_schema
|
mtr
|
mtr.global_suppressions OK
|
mtr.test_suppressions OK
|
performance_schema
|
test
|
test.t OK
|
Phase 7/7: Running 'FLUSH PRIVILEGES'
|
OK
|
sujatha@sujatha:~/bug_repo/test-10.5/bld/mysql-test$ ../client/mysql -uuser1 -S/home/sujatha/bug_repo/test-10.5/bld/mysql-test/var/tmp/mysqld.2.sock
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 19
|
Server version: 10.5.14-MariaDB-debug-log Source distribution
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> show privileges;
|
+--------------------------+---------------------------------------+--------------------------------------------------------------------+
|
| Privilege | Context | Comment |
|
+--------------------------+---------------------------------------+--------------------------------------------------------------------+
|
| Alter | Tables | To alter the table |
|
| Alter routine | Functions,Procedures | To alter or drop stored functions/procedures |
|
| Create | Databases,Tables,Indexes | To create new databases and tables |
|
| Create routine | Databases | To use CREATE FUNCTION/PROCEDURE |
|
| Create temporary tables | Databases | To use CREATE TEMPORARY TABLE |
|
| Create view | Tables | To create new views |
|
| Create user | Server Admin | To create new users |
|
| Delete | Tables | To delete existing rows |
|
| Delete history | Tables | To delete versioning table historical rows |
|
| Drop | Databases,Tables | To drop databases, tables, and views |
|
| Event | Server Admin | To create, alter, drop and execute events |
|
| Execute | Functions,Procedures | To execute stored routines |
|
| File | File access on server | To read and write files on the server |
|
| Grant option | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess |
|
| Index | Tables | To create or drop indexes |
|
| Insert | Tables | To insert data into tables |
|
| Lock tables | Databases | To use LOCK TABLES (together with SELECT privilege) |
|
| Process | Server Admin | To view the plain text of currently executing queries |
|
| Proxy | Server Admin | To make proxy user possible |
|
| References | Databases,Tables | To have references on tables |
|
| Reload | Server Admin | To reload or refresh tables, logs and privileges |
|
| Binlog admin | Server | To purge binary logs |
|
| Binlog monitor | Server | To use SHOW BINLOG STATUS and SHOW BINARY LOG |
|
| Binlog replay | Server | To use BINLOG (generated by mariadb-binlog) |
|
| Replication master admin | Server | To monitor connected slaves |
|
| Replication slave admin | Server | To start/stop slave and apply binlog events |
|
| Slave monitor | Server | To use SHOW SLAVE STATUS and SHOW RELAYLOG EVENTS |
|
| Replication slave | Server Admin | To read binary log events from the master |
|
| Select | Tables | To retrieve rows from table |
|
| Show databases | Server Admin | To see all databases with SHOW DATABASES |
|
| Show view | Tables | To see views with SHOW CREATE VIEW |
|
| Shutdown | Server Admin | To shut down the server |
|
| Super | Server Admin | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc. |
|
| Trigger | Tables | To use triggers |
|
| Create tablespace | Server Admin | To create/alter/drop tablespaces |
|
| Update | Tables | To update existing rows |
|
| Set user | Server | To create views and stored routines with a different definer |
|
| Federated admin | Server | To execute the CREATE SERVER, ALTER SERVER, DROP SERVER statements |
|
| Connection admin | Server | To bypass connection limits and kill other users' connections |
|
| Read_only admin | Server | To perform write operations even if @@read_only=ON |
|
| Usage | Server Admin | No privileges - allow connect only |
|
+--------------------------+---------------------------------------+--------------------------------------------------------------------+
|
41 rows in set (0.001 sec)
|
|
MariaDB [(none)]> show slave status\G;
|
*************************** 1. row ***************************
|
Slave_IO_State:
|
Master_Host: localhost
|
Master_User: root
|
Master_Port: 16000
|
Connect_Retry: 60
|
Master_Log_File: master-bin.000001
|
Read_Master_Log_Pos: 1105
|
Relay_Log_File: slave-relay-bin.000002
|
Relay_Log_Pos: 1405
|
Relay_Master_Log_File: master-bin.000001
|
Slave_IO_Running: No
|
Slave_SQL_Running: No
|
Replicate_Do_DB:
|
Replicate_Ignore_DB:
|
Replicate_Do_Table:
|
Replicate_Ignore_Table: test.t_ignored1
|
Replicate_Wild_Do_Table:
|
Replicate_Wild_Ignore_Table:
|
Last_Errno: 0
|
Last_Error:
|
Skip_Counter: 0
|
Exec_Master_Log_Pos: 1105
|
Relay_Log_Space: 1993
|
Until_Condition: None
|
Until_Log_File:
|
Until_Log_Pos: 0
|
Master_SSL_Allowed: No
|
Master_SSL_CA_File:
|
Master_SSL_CA_Path:
|
Master_SSL_Cert:
|
Master_SSL_Cipher:
|
Master_SSL_Key:
|
Seconds_Behind_Master: NULL
|
Master_SSL_Verify_Server_Cert: No
|
Last_IO_Errno: 0
|
Last_IO_Error:
|
Last_SQL_Errno: 0
|
Last_SQL_Error:
|
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 0
|
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: No
|
Gtid_IO_Pos:
|
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: optimistic
|
SQL_Delay: 0
|
SQL_Remaining_Delay: NULL
|
Slave_SQL_Running_State:
|
Slave_DDL_Groups: 0
|
Slave_Non_Transactional_Groups: 0
|
Slave_Transactional_Groups: 0
|
1 row in set (0.001 sec)
|
|
ERROR: No query specified
|
|