Sunday- October 22, 2017

Order Now!
Home About Us Articles Contact FAQ HelpDesk Place Order
Login Status
User Name:

Password:

Forgot your password?
Click here for reset.

   

Main Menu
· Home
· WebHosting
· Dedicated Server
· Payment Method
· Contact Us
· About Us
· Server Status

Client Tools
· Client Info.
· Order Info.
· Invoice Info.
· Payment Confirmation
· Place Order
· Client Testimonial






FAQ: Database Manager and phpMyAdmin  (6 questions)
All about Database Manager and phpMyAdmin
  1. How I can connect to my MySQL database? What settings should I use for my script/software?
  2. How I can access my database online?
  3. HOw to create database and assign users
  4. How to add/remove user for certain database
  5. How to grant user permissions to a MySQL database
  6. I can't establish MySQL connection and get this error: "Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ?
FAQ

FAQ Answers: Database Manager and phpMyAdmin
  1. How I can connect to my MySQL database? What settings should I use for my script/software?
    The correct MySQL database settings are:

    DB Host: See your MySQL Database Manager section under DB Host column;
    DB Port: 3306
    DB Name: The database name you have assigned, listed inside Database Manager section of your Control Panel;
    DB Username: The database username you have assigned, listed inside Database Manager section of your Control Panel;
    DB Password: The database password you have assigned;

    Top

  2. How I can access my database online?
    Login your Contorl Panel, click on the phpMyAdmin icon, then use the following credentials:

    Username: the database name you have assigned, listed inside Database Manager section of your Control Panel
    Password: the database password you have assigned

    Top

  3. HOw to create database and assign users
    To create a MySQL database:

    1. Click on the MySQL databases button on the home page.
    2. Enter the name of the database in the Db field.
    3. Click on the Add Db button. The database will be added to the /var/lib/mysql folder.
    You need to create at least one database user and grant that user permission to use the new database. Refer to Creating a MySQL user and Grant a user's permissions to a MySQL database for more information.


    Top

  4. How to add/remove user for certain database
    To create a MySQL user:

    1. Click on the MySQL databases button on the home page.
    2. Enter the user's name in the UserName field and the user's password in the Password field.
    3. Click on the Add User button.



    To remove a user:

    1. Click on the MySQL databases button on the home page.
    2. Click on the Delete button next to the specific user in the Users area.

    Top

  5. How to grant user permissions to a MySQL database
    Once you have created a user to use a database you need to grant that user permission to use the database. If you have not yet created a user, refer to Creating a MySQL user for more information.

    To grant user permissions to a MySQL database:

    1. Click on the MySQL databases button on the home page.
    2. Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.
    3. Click on the Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the MySQL window.


    Top

  6. I can't establish MySQL connection and get this error: "Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ?
    You cannot make connection through socket, please use MySQL settings to establish connection(see above question).

    Top

FAQ

Copyright MuliaHost 2002-2011
Powered By phpCOIN | Design by 7dana.com