Parameters and methods of connecting to MySQL

  • Host name (server) where MySQL is hosted: localhost or 127.0.0.1 or IP of your server
  • Port: 3306
  • Login: which you created in your cPanel (or other control panel) Example: user_loginbd
  • Password: which you created in your cpanel (or other control panel) Example: Hs8%68ws
  • Database name: which you created in your cpanel (or other control panel) Example: user_bd

 

For security purposes, direct access to MySQL servers from the Internet is prohibited, and clients are provided with the following options for administering and using the database:

  • working with the database from user scripts in Perl, PHP, etc.
  • database management via the phpMyAdmin web interface. You set the access details yourself when creating the Database in your control panel
Was this answer helpful? 49 Users Found This Useful (185 Votes)

Most Popular Articles

phpMyAdmin - access MySQL via a web browser

To access MySQL from a regular web browser, clients can use the phpMyAdmin tool. PhpMyAdmin is a...
Import and export MySQL data via unix Shell

Exporting and importing data into MySQL is usually required when moving information from one...
How to work with MySQL from PHP scripts

To work with MySQL, you can use the tools built into the PHP language, which are already...
How to work with MySQL from Perl scripts

To work with MySQL from Perl scripts, the DBI module is usually used. This allows you to...