mysql -u root -pstatus

mysql -u root -pROOTPASS status

shell> mysqladmin proc stat
         +----+-------+-----------+----+---------+------+-------+------------------+
         | Id | User  | Host      | db | Command | Time | State | Info             |
         +----+-------+-----------+----+---------+------+-------+------------------+
         | 51 | monty | localhost |    | Query   | 0    |       | show processlist |
         +----+-------+-----------+----+---------+------+-------+------------------+
         Uptime: 1473624  Threads: 1  Questions: 39487
         Slow queries: 0  Opens: 541  Flush tables: 1
         Open tables: 19  Queries per second avg: 0.0268

      The mysqladmin status command result displays the following values:

      ·  Uptime

         The number of seconds the MySQL server has been running.

      ·  Threads

         The number of active threads (clients).

      ·  Questions

         The number of questions (queries) from clients since the server was started.

      ·  Slow queries

         The number of queries that have taken more than long_query_time seconds. See Section 2.4, “The Slow Query
         Log”.

      ·  Opens

root@andromeda:~# mysqladmin proc stat
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

root@andromeda:~# mysqladmin status -u root -p
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

root@andromeda:~# mysqladmin status -u root -p
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

rams | Posted on Jan. 19 2009, 21:22
1.Свирки
2.IF НЕ ТИ СЕ ПРАВИ 1. - GOTO "четене му е майката"
3.IF 1. и 2. не ти се отдават - GOTO "при Чичко БИЛ" /явно линукс няма да ти е силната страна"

а паролата знаеш ли си я?
явно не си я знаеш..

[code]root@andromeda:/etc/rc.d# mysqld_safe --skip-grant-tables &
[1] 28787
root@andromeda:/etc/rc.d# nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql

root@andromeda:/etc/rc.d# mysql -u root
Welcome to the MySQL monitor.  Commands end with; or \g.
Your MySQL connection id is 1
Server version: 5.0.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=PASSWORD("NewPasswd") where User='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

root@andromeda:/etc/rc.d# /etc/rc.d/rc.mysqld stop

root@andromeda:/etc/rc.d# /etc/rc.d/rc.mysqld start
root@andromeda:/etc/rc.d# nohup: redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql

root@andromeda:~# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with; or \g.
Your MySQL connection id is 2
Server version: 5.0.67 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>