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, 4874👍, 0💬
Popular Posts:
How do I use a scriptlet to initialize a newly instantiated bean? A jsp:useBean action may optionall...
Describe in detail Basic of SAO architecture of Remoting? For these types of questions interviewer e...
Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQ...
What is Shell scripting A shell script is a script written for the shell, or command line interprete...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.