{"id":1771,"date":"2024-02-27T12:20:15","date_gmt":"2024-02-27T12:20:15","guid":{"rendered":"https:\/\/www.devopssupport.in\/blog\/?p=1771"},"modified":"2024-03-02T12:24:00","modified_gmt":"2024-03-02T12:24:00","slug":"setting-up-mysql-database-in-php","status":"publish","type":"post","link":"https:\/\/www.devopssupport.in\/blog\/setting-up-mysql-database-in-php\/","title":{"rendered":"Setting Up MySQL Database in PHP"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Step 1: Install MySQL<\/strong><\/p>\n\n\n\n

If you haven’t already installed MySQL on your server or local development environment, you’ll need to do so. You can download MySQL from the official website (https:\/\/dev.mysql.com\/downloads\/<\/a>) and follow the installation instructions for your operating system.<\/p>\n\n\n\n

Step 2: Start MySQL Server<\/strong><\/p>\n\n\n\n

Once MySQL is installed, start the MySQL server. On most systems, you can do this by running a command such as.<\/p>\n\n\n\n

sudo service mysql start\r\n<\/code><\/pre>\n\n\n\n
Step 3: Access MySQL Shell<\/strong><\/p>\n\n\n\n
Next, access the MySQL shell by running the following command.<\/p>\n\n\n\n
mysql -u root -p\r<\/code><\/pre>\n\n\n\n
You’ll be prompted to enter the root password for MySQL. Once logged in, you’ll have access to the MySQL command-line interface.<\/p>\n\n\n\n
Step 4: Create a Database<\/strong><\/p>\n\n\n\n
Now that you’re in the MySQL shell, let’s create a new database. Execute the following SQL command to create a database named mydatabase<\/code>.<\/p>\n\n\n\n
CREATE DATABASE mydatabase;\r\n<\/code><\/pre>\n\n\n\n
You can replace mydatabase<\/code> with the name of your desired database.<\/p>\n\n\n\n
Step 5: Create a User<\/strong><\/p>\n\n\n\n
After creating the database, let’s create a new user and grant them privileges to access the database. Run the following command to create a user named myuser<\/code> with a password.<\/p>\n\n\n\n
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';\r<\/code><\/pre>\n\n\n\n
Replace myuser<\/code> with your desired username and mypassword<\/code> with your desired password.<\/p>\n\n\n\n
Step 6: Grant Privileges<\/strong><\/p>\n\n\n\n
Next, grant the user privileges to access and manipulate the database. Execute the following command.<\/p>\n\n\n\n
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';\r\n<\/code><\/pre>\n\n\n\n
This grants the user myuser<\/code> full privileges on the mydatabase<\/code> database. If you want to grant specific privileges, you can replace ALL PRIVILEGES<\/code> with the desired privileges (e.g., SELECT, INSERT, UPDATE, DELETE<\/code>).<\/p>\n\n\n\n
Step 7: Flush Privileges<\/strong><\/p>\n\n\n\n
After granting privileges, flush the MySQL privileges to ensure that they take effect.<\/p>\n\n\n\n
FLUSH PRIVILEGES;\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Step 1: Install MySQL If you haven’t already installed MySQL on your server or local development environment, you’ll need to do so. You can download MySQL from… <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1771","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/comments?post=1771"}],"version-history":[{"count":1,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1771\/revisions"}],"predecessor-version":[{"id":1774,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1771\/revisions\/1774"}],"wp:attachment":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/media?parent=1771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/categories?post=1771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/tags?post=1771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}