The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.
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:".... Views: 4272 |
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... Views: 4146 |
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... Views: 4534 |
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,... Views: 3966 |
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... Views: 3999 |
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... Views: 4169 |
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... Views: 4526 |
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... Views: 4558 |
What should I put for the MySQL host name?You would use localhost Views: 4239 |
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... Views: 4074 |