how to create mysql in 000webhost

In previous post we discussed how to create mysql in 000webhost.We need atleast  one mysql account to connect a wordpress and a 000webhost account.Let we see one by one.

Install wordpress in 000 Webhost account

 

  • When you done the above step ,see your website.It will be like below,

image

  • Next when you click wordpress you will be asked to create config.php file like below,

image

 

  • Now return to 000 webhost account and goto cpanel,Choose mysql like below,

image

 

  • And in mysql page you will be asked to create database.Like below image fill details.

image

   

  • Now you will get like below .It means you have created a mysql account.Note the information in notepad or somewhere because we need to add this in file manager.

image

  • Now goto file manager

 

image

 

  • It will ask to enter password just use your account password ,username will be created automatically for you and click continue

image

 

  • Click public_html

image

  • In public-html folder click wordpress.

image

  • In wordpress folder you can see wp-config-sample.php (or)wp-config.php.Sometimes you can see both you choose anyone and click edit.

image

  • In the editor,you can see

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'DATABASE NAME');

/** MySQL database username */
define('DB_USER', 'USERNAME');

/** MySQL database password */
define('DB_PASSWORD', 'PASSWORD');

/** MySQL hostname */
define('DB_HOST', 'HOSTNAME');

And you have already created a database and it will be like below,

$mysql_host = "mysql3.000webhost.com";
$mysql_database = "a6620474_123";
$mysql_user = "a6620474_123";
$mysql_password =   " ***************";
Now copy a6620474_123 and paste a6620474_123 in the editor by replacing “DATABASE NAME” and “USERNAME”.Also replace password which you have created in database.Replace “HOSTNAME” by mysql3.000webhost.com.Finally your changed config.php will be,

    /** The name of the database for WordPress */
    define('DB_NAME', 'a6620474_123');

    /** MySQL database username */
    define('DB_USER', 'a6620474_3378');

    /** MySQL database password */
    define('DB_PASSWORD', ' ****************** ');

    /** MySQL hostname */
    define('DB_HOST', 'mysql3.000webhost.com');

  • And click blue Save icon.

image

  • Now goto website url.Now it will be like below,

 

image

  • Again fill the details like below which you entered in config.php.

image

  • When all details filled correct click submit finally it asks click install now.It asks to fill some details like below.It is easy just give title name ,username and password for wordpress dashboard ,mail.and click install wordpress.

image

  • And your wordpress was installed successfully.Now your dashboard will be www.example.com/wordpress/wp-admin (or) www.example.com/wp-admin.

image

Now see your website still you can see wordpress folder.When you click  wordpress  you can find your site alive.

  • At present your website live at www.example.com/wordpress
  • How to make your website live in www.example.com?

We will share how to solve index of/ problem in next post.

Print Friendly and PDF
SHARE

About me

Hi. I am interested in blogging.And sometimes play with webdesign,web development,domain sale,designing logo and more.

    Blogger Comment
    Facebook Comment

0 comments :

Post a Comment