1. Login to DirectAdmin with your control panel username & password. Your database must already be created in order to use phpMyAdmin. 2. Go to “MySQL Management”
To delete database that you have created, simply click the DB tab and hover your mouse over the database you want to perform these operations on. Then, click on the respective buttons, and then press “OK” when prompted.
Step 1. Search for option MySQL Management Step 2. Click on the ‘Create New Database’ Option Step 3. Fill the Database name, user and password. Step 4. You can create the database by clicking on the ‘Create Database’ button. Created Database will be shown at MySQL Management console.
1. Login to your DirectAdmin, click on MySQL Management. 2. Click on Create new Database. 3. Insert the new database info accordingly. If you decide to use an existing user, select the user from the drop-down list of existing users. If not, proceed to create a new user. Click on Create to proceed. 4. You
When you cannot access your website and you are seeing this kind of message: SQL query: DELETE FROM sessions WHERE expiry <1349879630 MySQL said: #126 – Incorrect key file for table ‘./your_database/sessions.MYI’; try to repair it It is possible that the hosting server had crashed and rebooted. After the server has restarted, your database tables
Mysqldump is an effective tool to backup MySQL database. It creates an .sql file with DROP table, CREATE table and INSERT into sql-statements of the source database. 1. To back up a database, use the command as below: #mysqldump -u db_username -p [database_name] > dumpfilename.sql Key in the password when requested. 2. To restore a
Remote access to MySQL database on Windows Shared Hosting is enabled by default, simply use SQLyog available at http://code.google.com/p/sqlyog/downloads/list: 1. Install and run SQLyog 2. Click on New… 3. Enter the following info: Host Address: yourdomain.com Username: DatabaseUser Password: DatabaseUserPassword Port: 3306 Database: DatabaseName 4. Click on connect
If your web server does not have phpMyAdmin installed, you may add remote host for your database by first accessing your web server via SSH. Step 1 – Login into MySQL server. Step 2 – If you wish to allow database user “ips1” to access database “myDatabase” at IP address “192.168.1.1“, execute the following command.
Create New Database 1. Login to the mysql client. mysql -u root -p
Login to mysql server using current da_admin include the following commands in the shell prompt: 1. Use mysql database(type command at mysql> prompt): mysql> use mysql; 2. Change password for user da_admin, enter: mysql> update user set password=PASSWORD(“NEWPASSWD”) where User=’da_admin’; 3. Finally, reload the privileges with: mysql> flush privileges; mysql> quit; 4. DirectAdmin