登陆Mysql
查看库列表
mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || bacula || mysql || test |+--------------------+4 rows in set (0.00 sec)
选择表单
mysql> use baculaReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed
查看表
mysql> show tables;+-----------------------+| Tables_in_bacula |+-----------------------+| BaseFiles || CDImages || Client || Counters || Device || File || FileSet || Filename || Job || JobHisto || JobMedia || Location || LocationLog || Log || Media || MediaType || Path || PathHierarchy || PathVisibility || Pool || RestoreObject || Snapshot || Status || Storage || UnsavedFiles || Version || webacula_client_acl || webacula_command_acl || webacula_dt_commands || webacula_dt_resources || webacula_fileset_acl || webacula_job_acl || webacula_jobdesc || webacula_logbook || webacula_logtype || webacula_php_session || webacula_pool_acl || webacula_resources || webacula_roles || webacula_storage_acl || webacula_users || webacula_version || webacula_where_acl |+-----------------------+43 rows in set (0.00 sec)
查看表内容
mysql> select * from webacula_users;+------+-------+--------------+------+-------+---------------------+------------+---------+--------+---------+| id | login | pwd | name | email | create_login | last_login | last_ip | active | role_id |+------+-------+--------------+------+-------+---------------------+------------+---------+--------+---------+| 1000 | root | .JL.a9yNys40 | root | NULL | 2017-10-15 17:39:33 | NULL | NULL | 1 | 1 |+------+-------+--------------+------+-------+---------------------+------------+---------+--------+---------+1 row in set (0.00 sec)
更新需要修改的表内容
mysql> update webacula_users set pwd=‘$P$BWSapkvMnGs61zsWnpd.JL.a9yNys40‘ where name="root";Query OK, 1 row affected (0.00 sec)Rows matched: 1 Changed: 1 Warnings: 0
查看修改结果
mysql> select * from webacula_users;+------+-------+------------------------------------+------+-------+---------------------+------------+---------+--------+---------+| id | login | pwd | name | email | create_login | last_login | last_ip | active | role_id |+------+-------+------------------------------------+------+-------+---------------------+------------+---------+--------+---------+| 1000 | root | $P$BWSapkvMnGs61zsWnpd.JL.a9yNys40 | root | NULL | 2017-10-15 17:39:33 | NULL | NULL | 1 | 1 |+------+-------+------------------------------------+------+-------+---------------------+------------+---------+--------+---------+1 row in set (0.00 sec)
用新密码登陆
本文出自 “Ogre之路” 博客，请务必保留此出处http://ogrecn.blog.51cto.com/12502697/1974570
webacula root登陆密码错误解决方案
原文地址：http://ogrecn.blog.51cto.com/12502697/1974570