![]() Now restart IIS by going to “Start,” select the “ Search Field,” type the word “iisreset.” and click ENTER. Go to c:\php\php.ini from your text editorĮnsure you uncomment the text below by omitting the semicolon ON some_database_name.* TO 'some_username' Step 4 – Configuring PHP application to Access MySQL ![]() To ensure the user gains access to this database, run the command below: mysql> GRANT ALTER, So, to ensure the user access the file, type the command below: mysql>CREATE DATABASE IF NOT EXISTS some_database_name To provision the user, run the command below: mysql>CREATE USER 'some_username' IDENTIFIED BY 'some_password' īy default, the new user doesn’t have any rights on MySQL. Query OK, 0 rows affected (0.23 sec) Step 3 – Provision a New User and Database. Mysql> UPDATE user SET user='johndoe' WHERE user='root' Use the command below to change the actual name of the root user: mysql> USE mysql Mysql> DELETE FROM user WHERE user = 'root' AND host = '%' In the MySQL command prompt, run the following commands: mysql> use mysql Next, ensure the root account is restricted. Then go ahead and open the MySQL command and follow the process below: Start > All Programs > MySQL > MySQL Server 5.1 > MySQL Command Line Client. Start by removing any strange database account that exists in the system.To enable MySQL dynamic extension, uncomment on the following line on MySQL extension: extension=php_mysql.dll.Make sure the file extension_dir is pointing to the exact location of the PHP extensions.Also, conduct some changes in the Php.ini file: To ensure PHP is working well with MySQL. Click “Finish” to exit from the wizard.Click “Execute” to apply these changes.Input the password of your choice for the account and proceed to the next step.Enable both options on the Windows section and click “ Next.”.Adjust the settings for the desired network depending on the environment, then click “ Next”.Select the number of connections needed in your system.You can also opt to use “ Non-Transactional Database Only” option for improved performance with low cost on memory and disc space.This can be used if you’re dealing with multiple statement transactions on your web applications or when there are other advanced levels that require isolation, or foreign constraints as well as ACID (Atomic, Consistent, Isolated, and Durable) Features. In this section, you can either choose Multifunctional Database or Transactional Database options for MyISAM or InnoDB storage engines.Choose your preferred database, and click “ Next”.When setting up your MySQL server, remember to select the type of server as a “ Dedicated MySQL Server Machine,” and proceed to the next step. Choose a server that best fits your environment. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |