How to add new WordPress administrator user via mysql command line
Backup firstly your database using mysqldump command
mysqldump your_database > your_database.sql
mysql>
… Read the rest
Notes
Backup firstly your database using mysqldump command
mysqldump your_database > your_database.sql
mysql>
… Read the rest
If you need to manually disable a module you can do so in the database. Before you start, do a mysqldump (or export) of your Drupal db to a local file in case things go wrong and you need to roll back.
Login to MySQL with root privileges
root@server [~]# mysql |
Create the Database
mysql > create database cleint_dbname; |
Create the User
mysql > create user cleint_dbuser; |
Grant privileges for this chain database + database username + password
… Read the restHere I will show you how to change theme of Wordpres site to another
You may find the list of avaiable themes under ./wp-content/themes folder … Read the rest
Here is I will show you how to reset password for WordPress dashboard
For example we have database with name test_test … Read the rest
Here I will show you how to install PhpMyAdmin and make it work with your ISP Manager … Read the rest
Login as root via ssh to your server and run the following commands
mysql
use eximstats;… Read the rest
In order to fix this error you need to remove username from /etc/group file
In my case next error that I’ve got was
“Sorry, a mysql user with the username already exists”
Here is some steps to fix this… Read the rest
If you are getting horde session handler error, then please check if horde db is present on server or not. You can use following steps.
mysqlshow |grep horde
It should give you output like… Read the rest