Microsoft Windows [Versión 10.0.22621.1702] (c) Microsoft Corporation. Todos los derechos reservados. C:\Users\pompi>cd/xampp/mysql/bin C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> exit Bye C:\xampp\mysql\bin>mysql -u root -p -h localhost Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> select user() -> ; +----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.001 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | academia | | basedatosii | | basedatosiii | | createinsert | | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 9 rows in set (0.057 sec) MariaDB [(none)]> create database prueba; Query OK, 1 row affected (0.011 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | academia | | basedatosii | | basedatosiii | | createinsert | | information_schema | | mysql | | performance_schema | | phpmyadmin | | prueba | | test | +--------------------+ 10 rows in set (0.002 sec) MariaDB [(none)]> use mysql; Database changed MariaDB [mysql]> show tables mysql, -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql,' at line 1 MariaDB [mysql]> show tables mysql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql' at line 1 MariaDB [mysql]> show table mysql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql' at line 1 MariaDB [mysql]> show msql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'msql' at line 1 MariaDB [mysql]> show mysql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql' at line 1 MariaDB [mysql]> select user from user; +------+ | User | +------+ | root | | root | | pma | | root | +------+ 4 rows in set (0.082 sec) MariaDB [mysql]> describe user; +------------------------+---------------------+------+-----+----------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------+---------------------+------+-----+----------+-------+ | Host | char(60) | NO | | | | | User | char(80) | NO | | | | | Password | longtext | YES | | NULL | | | Select_priv | varchar(1) | YES | | NULL | | | Insert_priv | varchar(1) | YES | | NULL | | | Update_priv | varchar(1) | YES | | NULL | | | Delete_priv | varchar(1) | YES | | NULL | | | Create_priv | varchar(1) | YES | | NULL | | | Drop_priv | varchar(1) | YES | | NULL | | | Reload_priv | varchar(1) | YES | | NULL | | | Shutdown_priv | varchar(1) | YES | | NULL | | | Process_priv | varchar(1) | YES | | NULL | | | File_priv | varchar(1) | YES | | NULL | | | Grant_priv | varchar(1) | YES | | NULL | | | References_priv | varchar(1) | YES | | NULL | | | Index_priv | varchar(1) | YES | | NULL | | | Alter_priv | varchar(1) | YES | | NULL | | | Show_db_priv | varchar(1) | YES | | NULL | | | Super_priv | varchar(1) | YES | | NULL | | | Create_tmp_table_priv | varchar(1) | YES | | NULL | | | Lock_tables_priv | varchar(1) | YES | | NULL | | | Execute_priv | varchar(1) | YES | | NULL | | | Repl_slave_priv | varchar(1) | YES | | NULL | | | Repl_client_priv | varchar(1) | YES | | NULL | | | Create_view_priv | varchar(1) | YES | | NULL | | | Show_view_priv | varchar(1) | YES | | NULL | | | Create_routine_priv | varchar(1) | YES | | NULL | | | Alter_routine_priv | varchar(1) | YES | | NULL | | | Create_user_priv | varchar(1) | YES | | NULL | | | Event_priv | varchar(1) | YES | | NULL | | | Trigger_priv | varchar(1) | YES | | NULL | | | Create_tablespace_priv | varchar(1) | YES | | NULL | | | Delete_history_priv | varchar(1) | YES | | NULL | | | ssl_type | varchar(9) | YES | | NULL | | | ssl_cipher | longtext | NO | | | | | x509_issuer | longtext | NO | | | | | x509_subject | longtext | NO | | | | | max_questions | bigint(20) unsigned | NO | | 0 | | | max_updates | bigint(20) unsigned | NO | | 0 | | | max_connections | bigint(20) unsigned | NO | | 0 | | | max_user_connections | bigint(21) | NO | | 0 | | | plugin | longtext | NO | | | | | authentication_string | longtext | NO | | | | | password_expired | varchar(1) | NO | | | | | is_role | varchar(1) | YES | | NULL | | | default_role | longtext | NO | | | | | max_statement_time | decimal(12,6) | NO | | 0.000000 | | +------------------------+---------------------+------+-----+----------+-------+ 47 rows in set (0.024 sec) MariaDB [mysql]> select user, password, host from use; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'use' at line 1 MariaDB [mysql]> select user, password, host from user; +------+----------+-----------+ | User | Password | Host | +------+----------+-----------+ | root | | localhost | | root | | 127.0.0.1 | | root | | ::1 | | pma | | localhost | +------+----------+-----------+ 4 rows in set (0.002 sec) MariaDB [mysql]> CREATE USER 'admon'@'localhost' IDENTIFIED BY 'admin'; Query OK, 0 rows affected (0.018 sec) MariaDB [mysql]> select user from user; +-------+ | User | +-------+ | root | | root | | admon | | pma | | root | +-------+ 5 rows in set (0.002 sec) MariaDB [mysql]> MariaDB [mysql]> select user, password, host from user; +-------+-------------------------------------------+-----------+ | User | Password | Host | +-------+-------------------------------------------+-----------+ | root | | localhost | | admon | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 | localhost | | root | | 127.0.0.1 | | root | | ::1 | | pma | | localhost | +-------+-------------------------------------------+-----------+ 5 rows in set (0.002 sec) MariaDB [mysql]> exit Bye C:\xampp\mysql\bin>mysql -uadmon root -p Enter password: ERROR 1045 (28000): Access denied for user 'admon'@'localhost' (using password: NO) C:\xampp\mysql\bin>mysql -uadmon root -p Enter password: ***** ERROR 1044 (42000): Access denied for user 'admon'@'localhost' to database 'root' C:\xampp\mysql\bin>mysql -uadmon root -p Enter password: ***** ERROR 1044 (42000): Access denied for user 'admon'@'localhost' to database 'root' C:\xampp\mysql\bin>mysql -uadmon root -p Enter password: ***** ERROR 1044 (42000): Access denied for user 'admon'@'localhost' to database 'root' C:\xampp\mysql\bin>mysql -uadmon -p Enter password: ***** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 14 Server version: 10.4.28-MariaDB mariadb.org binary 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 tables; ERROR 1046 (3D000): No database selected MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.001 sec) MariaDB [(none)]> create database prueba2; ERROR 1044 (42000): Access denied for user 'admon'@'localhost' to database 'prueba2' MariaDB [(none)]> MariaDB [(none)]> exit Bye C:\xampp\mysql\bin>mysql -u root -p -h localhost Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 15 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> CREATE USER 'admon1'@'localhost' IDENTIFIED BY 'admin'; Query OK, 0 rows affected (0.002 sec) MariaDB [(none)]> CREATE USER 'jhonier'@'localhost' IDENTIFIED BY '123456'; Query OK, 0 rows affected (0.003 sec) MariaDB [(none)]> select user from user; ERROR 1046 (3D000): No database selected MariaDB [(none)]> select user from mysql.user; +---------+ | User | +---------+ | root | | root | | admon | | admon1 | | jhonier | | pma | | root | +---------+ 7 rows in set (0.002 sec) MariaDB [(none)]> select user, password, host from user; ERROR 1046 (3D000): No database selected MariaDB [(none)]> select user, password, host from msql.user; ERROR 1146 (42S02): Table 'msql.user' doesn't exist MariaDB [(none)]> select user, password, host from mysql.user; +---------+-------------------------------------------+-----------+ | User | Password | Host | +---------+-------------------------------------------+-----------+ | root | | localhost | | admon | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 | localhost | | root | | 127.0.0.1 | | root | | ::1 | | pma | | localhost | | admon1 | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 | localhost | | jhonier | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | localhost | +---------+-------------------------------------------+-----------+ 7 rows in set (0.003 sec) MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'admon'@'localhost'; Query OK, 0 rows affected (0.003 sec) MariaDB [(none)]> show grants for 'admin' GRANT ALL PRIVILEGES ON *.* TO 'admon'@'localhost'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GRANT ALL PRIVILEGES ON *.* TO 'admon'@'localhost'' at line 1 MariaDB [(none)]> source C:\Users\pompi\Downloads\turismo.sql Query OK, 0 rows affected (0.003 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.003 sec) Database changed Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.020 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 11 rows affected (0.005 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [turismo]> select user(); +----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.001 sec) MariaDB [turismo]> show datasese; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'datasese' at line 1 MariaDB [turismo]> show databases; +--------------------+ | Database | +--------------------+ | academia | | basedatosii | | basedatosiii | | createinsert | | information_schema | | mysql | | performance_schema | | phpmyadmin | | prueba | | test | | turismo | +--------------------+ 11 rows in set (0.001 sec) MariaDB [turismo]> MariaDB [turismo]> exit Bye C:\xampp\mysql\bin>mysql -uadmon root -p Enter password: ***** ERROR 1049 (42000): Unknown database 'root' C:\xampp\mysql\bin>mysql -uadmon -p Enter password: ***** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 17 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> select use(); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'use()' at line 1 MariaDB [(none)]> select user(); +-----------------+ | user() | +-----------------+ | admon@localhost | +-----------------+ 1 row in set (0.001 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | academia | | basedatosii | | basedatosiii | | createinsert | | information_schema | | mysql | | performance_schema | | phpmyadmin | | prueba | | test | | turismo | +--------------------+ 11 rows in set (0.001 sec) MariaDB [(none)]> create database jhonier; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | academia | | basedatosii | | basedatosiii | | createinsert | | information_schema | | jhonier | | mysql | | performance_schema | | phpmyadmin | | prueba | | test | | turismo | +--------------------+ 12 rows in set (0.001 sec) MariaDB [(none)]> describe jhonier; ERROR 1046 (3D000): No database selected MariaDB [(none)]> exit Bye C:\xampp\mysql\bin>select user(); "select" no se reconoce como un comando interno o externo, programa o archivo por lotes ejecutable. C:\xampp\mysql\bin>select user(); "select" no se reconoce como un comando interno o externo, programa o archivo por lotes ejecutable. C:\xampp\mysql\bin>mysql -u root -p -h localhost Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 18 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> select user(); +----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.001 sec) MariaDB [(none)]> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP -> ON turismo.* -> TO 'admon3'@'localhost' IDENTIFIED BY '123'; Query OK, 0 rows affected (0.002 sec) MariaDB [(none)]> show grants for 'admon3'@'localhost'; +---------------------------------------------------------------------------------------------------------------+ | Grants for admon3@localhost | +---------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `admon3`@`localhost` IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `turismo`.* TO `admon3`@`localhost` | +---------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.002 sec) MariaDB [(none)]> exit Bye C:\xampp\mysql\bin>mysql -uadmon -p Enter password: *** ERROR 1045 (28000): Access denied for user 'admon'@'localhost' (using password: YES) C:\xampp\mysql\bin>mysql -uadmon -p Enter password: *** ERROR 1045 (28000): Access denied for user 'admon'@'localhost' (using password: YES) C:\xampp\mysql\bin>mysql -uadmon3 -p Enter password: *** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 21 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> select user(); +------------------+ | user() | +------------------+ | admon3@localhost | +------------------+ 1 row in set (0.001 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | | turismo | +--------------------+ 3 rows in set (0.001 sec) MariaDB [(none)]> use turismo; Database changed MariaDB [turismo]> show tables; +-------------------+ | Tables_in_turismo | +-------------------+ | visitantes | +-------------------+ 1 row in set (0.001 sec) MariaDB [turismo]> select * from visitantes; +----+--------------------------+--------------+-----------+-------------+ | id | nombre | ciudad | sexo | montocompra | +----+--------------------------+--------------+-----------+-------------+ | 1 | Juan carlos Perez | Bogota | Masculino | 1500000 | | 2 | Elizabeth Torres | Bogota | Femenino | 1000000 | | 3 | Carmen Elvira Montes | Medellin | Femenino | 2000000 | | 4 | Diana Patricia Garcia | Medellin | Femenino | 2500000 | | 5 | Juan Alberto Cardona | Barranquilla | Masculino | 3500000 | | 6 | Felipe Ardila Castro | Barranquilla | Masculino | 3000000 | | 7 | Mariana Ocampo Cifuentes | Barranquilla | Femenino | 1800000 | | 8 | Mirian Ocampo Cifuentes | Cartagena | Femenino | 1600000 | | 9 | Martha Betancurt Ossa | Cartagena | Femenino | 6000000 | | 10 | Mateo Vasquez Posada | Cartagena | Masculino | 3000000 | | 11 | Pablo Andres Arboleda | Cartagena | Masculino | 1500000 | +----+--------------------------+--------------+-----------+-------------+ 11 rows in set (0.004 sec) MariaDB [turismo]> insert into visitantes(nombre,ciudad,sexo,montocompra) values('Jhonnier palomeque','Medellin','Masculino',5000000); Query OK, 1 row affected (0.004 sec) MariaDB [turismo]> select * from visitantes; +----+--------------------------+--------------+-----------+-------------+ | id | nombre | ciudad | sexo | montocompra | +----+--------------------------+--------------+-----------+-------------+ | 1 | Juan carlos Perez | Bogota | Masculino | 1500000 | | 2 | Elizabeth Torres | Bogota | Femenino | 1000000 | | 3 | Carmen Elvira Montes | Medellin | Femenino | 2000000 | | 4 | Diana Patricia Garcia | Medellin | Femenino | 2500000 | | 5 | Juan Alberto Cardona | Barranquilla | Masculino | 3500000 | | 6 | Felipe Ardila Castro | Barranquilla | Masculino | 3000000 | | 7 | Mariana Ocampo Cifuentes | Barranquilla | Femenino | 1800000 | | 8 | Mirian Ocampo Cifuentes | Cartagena | Femenino | 1600000 | | 9 | Martha Betancurt Ossa | Cartagena | Femenino | 6000000 | | 10 | Mateo Vasquez Posada | Cartagena | Masculino | 3000000 | | 11 | Pablo Andres Arboleda | Cartagena | Masculino | 1500000 | | 12 | Jhonnier palomeque | Medellin | Masculino | 5000000 | +----+--------------------------+--------------+-----------+-------------+ 12 rows in set (0.001 sec) MariaDB [turismo]> delete from visitantes where id=12; Query OK, 1 row affected (0.006 sec) MariaDB [turismo]> select * from visitantes; +----+--------------------------+--------------+-----------+-------------+ | id | nombre | ciudad | sexo | montocompra | +----+--------------------------+--------------+-----------+-------------+ | 1 | Juan carlos Perez | Bogota | Masculino | 1500000 | | 2 | Elizabeth Torres | Bogota | Femenino | 1000000 | | 3 | Carmen Elvira Montes | Medellin | Femenino | 2000000 | | 4 | Diana Patricia Garcia | Medellin | Femenino | 2500000 | | 5 | Juan Alberto Cardona | Barranquilla | Masculino | 3500000 | | 6 | Felipe Ardila Castro | Barranquilla | Masculino | 3000000 | | 7 | Mariana Ocampo Cifuentes | Barranquilla | Femenino | 1800000 | | 8 | Mirian Ocampo Cifuentes | Cartagena | Femenino | 1600000 | | 9 | Martha Betancurt Ossa | Cartagena | Femenino | 6000000 | | 10 | Mateo Vasquez Posada | Cartagena | Masculino | 3000000 | | 11 | Pablo Andres Arboleda | Cartagena | Masculino | 1500000 | +----+--------------------------+--------------+-----------+-------------+ 11 rows in set (0.001 sec) MariaDB [turismo]> exit Bye C:\xampp\mysql\bin>mysql -u root -p -h localhost Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 22 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> REVOKE delete ON turismo.* FROM 'admon3'@'localhost'; Query OK, 0 rows affected (0.003 sec) MariaDB [(none)]> show grants for 'admon3'@'localhost'; +---------------------------------------------------------------------------------------------------------------+ | Grants for admon3@localhost | +---------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `admon3`@`localhost` IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' | | GRANT SELECT, INSERT, UPDATE, CREATE, DROP ON `turismo`.* TO `admon3`@`localhost` | +---------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.001 sec) MariaDB [(none)]> exit Bye C:\xampp\mysql\bin>mysql -uadmon3 -p Enter password: *** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 23 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> select user(); +------------------+ | user() | +------------------+ | admon3@localhost | +------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> use turismo; Database changed MariaDB [turismo]> delete from visitantes where id=1; ERROR 1142 (42000): DELETE command denied to user 'admon3'@'localhost' for table `turismo`.`visitantes` MariaDB [turismo]> exit Bye C:\xampp\mysql\bin>mysql -u root -p -h localhost Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 24 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> seelect user(); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'seelect user()' at line 1 MariaDB [(none)]> select user(); +----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.001 sec) MariaDB [(none)]> DROP USER 'admon'@'localhost'; Query OK, 0 rows affected (0.002 sec) MariaDB [(none)]> select user from mysql.user; +---------+ | User | +---------+ | root | | root | | admon1 | | admon3 | | jhonier | | pma | | root | +---------+ 7 rows in set (0.002 sec) MariaDB [(none)]> SET PASSWORD FOR 'admon3'@'localhost' = PASSWORD('123456'); Query OK, 0 rows affected (0.003 sec) MariaDB [(none)]> exit Bye C:\xampp\mysql\bin>mysql -uadmon3 -p Enter password: *** ERROR 1045 (28000): Access denied for user 'admon3'@'localhost' (using password: YES) C:\xampp\mysql\bin>mysql -uadmon3 -p Enter password: ****** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 26 Server version: 10.4.28-MariaDB mariadb.org binary 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)]> se4lect user(); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'se4lect user()' at line 1 MariaDB [(none)]> select user(); +------------------+ | user() | +------------------+ | admon3@localhost | +------------------+ 1 row in set (0.001 sec) MariaDB [(none)]> exit Bye C:\xampp\mysql\bin>