PHP - MySQL - Databases — Knowledgebase

FIND YOUR ANSWER

Knowledgebase

Articles

How do I add a NEW user to my database?

To add a new user to your database, log into your control panel and click the "Manage MySQL" link. You will see a pair of dropmenu's there, labeled "User:" and "DB:". Choose the user you want to give…

How do I Add a user to my new database?

To add a user to a database in CWP (CentOS Web Panel), navigate to SQL Services > MySQL Manager, click Add User, enter a username and strong password, and assign the necessary database privileges.…

How do I Connect to MySQL with PHP?

Here's how to connect and begin querying the MySQL server from within your PHP scripts:1. Connect to the MySQL server: Use this statement to connect to the database server. Replace the username and…

How do I create a new database?

 To create a new MySQL database in Control Web Panel (CWP), log in and navigate to SQL Services > MySQL Manager, then click Create Database and User. Enter a database name, username,…

How do I upload a mysqldump of my database?

To upload and import a MySQL dump (SQL file) into CentOS Web Panel (CWP), you can use the web interface for smaller files or the command line for larger databases. Using phpMyAdmin…

My database name has added username_ to it - do I use that in my scripts?

In Control Web Panel (CWP), your database names and usernames usually follow a specific format, typically incorporating the CWP user account name as a prefix to ensure uniqueness. Here is how to…

What file extensions do I use for PHP?

For PHP files in Control Web Panel (CWP), the primary and recommended file extension is .php. Here are the specific details for using PHP file extensions in CWP: Standard Extension: Use .php for…

What is PHP?

PHP is a server-side HTML embedded scripting language used to create scripts and/or Web pages. In a HTML document, a PHP script is enclosed with special PHP tags. Because PHP is executed on the…

What should I put for the MySQL host name?

You would use localhost

Why do I get a PHP 500 Error?

This error is usually related with the permissions/ownership issue.Normallly, the permissions on php files should be 644 and the permissions on folders containing php files should be at 755 setting.…