Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Test a New User Account and Password
How To Test a New User Account and Password? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: FYIcenter.com
If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting to the server with user names and passwords:
>cd \mysql\bin >mysql -u dev ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password: NO) >mysql -u dev -pTEST ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password: YES) >mysql -u dev -pretneciyf Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 39 to server version: 5.0.24-community Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; Database changed mysql> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | articles | | links | +----------------+ 2 rows in set (0.04 sec)
2007-05-10, 4614👍, 0💬
Popular Posts:
What are the different elements in Functions points? The different elements in function points are a...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
What is the difference between RegisterClientScriptBloc kand RegisterStartupScript? RegisterClientSc...
How To Join a List of Keys with a List of Values into an Array? - PHP Script Tips - PHP Built-in Fun...
What is application domain? Explain. An application domain is the CLR equivalent of an operation sys...