MOTOSHARE ๐Ÿš—๐Ÿ๏ธ
Turning Idle Vehicles into Shared Rides & Earnings

From Idle to Income. From Parked to Purpose.
Earn by Sharing, Ride by Renting.
Where Owners Earn, Riders Move.
Owners Earn. Riders Move. Motoshare Connects.

With Motoshare, every parked vehicle finds a purpose. Owners earn. Renters ride.
๐Ÿš€ Everyone wins.

Start Your Journey with Motoshare

Setting Up MySQL Database in PHP

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 the official website (https://dev.mysql.com/downloads/) and follow the installation instructions for your operating system.

Step 2: Start MySQL Server

Once MySQL is installed, start the MySQL server. On most systems, you can do this by running a command such as.

sudo service mysql start

Step 3: Access MySQL Shell

Next, access the MySQL shell by running the following command.

mysql -u root -p

You’ll be prompted to enter the root password for MySQL. Once logged in, you’ll have access to the MySQL command-line interface.

Step 4: Create a Database

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.

CREATE DATABASE mydatabase;

You can replace mydatabase with the name of your desired database.

Step 5: Create a User

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 with a password.

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

Replace myuser with your desired username and mypassword with your desired password.

Step 6: Grant Privileges

Next, grant the user privileges to access and manipulate the database. Execute the following command.

GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';

This grants the user myuser full privileges on the mydatabase database. If you want to grant specific privileges, you can replace ALL PRIVILEGES with the desired privileges (e.g., SELECT, INSERT, UPDATE, DELETE).

Step 7: Flush Privileges

After granting privileges, flush the MySQL privileges to ensure that they take effect.

FLUSH PRIVILEGES;

Related Posts

Engineering Operations Assessment: Identifying Gaps and Building a Roadmap for Improvement

Consider a mid-sized software company that has invested heavily in its technical stack. Its applications run on managed Kubernetes clusters, infrastructure is defined in Terraform, pipelines deploy…

Read More

GitLab CI/CD Getting Started Guide: Build Your First Automated Pipeline

1. Introduction: Your First Step Into GitLab CI/CD Software development becomes significantly slower and more error-prone when teams rely on manual steps to build, test, and release…

Read More

How NoOps Is Changing the Way Modern IT Teams Manage Infrastructure

Modern information technology moves at a pace that often leaves traditional operational structures struggling to keep up. For a growing technology company, success brings rapid user adoption,…

Read More

How to Use GitHub Actions for DevOps Automation & Pipelines

In modern software engineering, moving code from a local branch to production traditionally requires a series of manual builds, tests, security checks, and deployments that slow delivery…

Read More

How to Use Jenkins for CI/CD: A Step-by-Step Guide

In modern software development, writing code is only half the journey. Getting that code safely, quickly, and reliably into the hands of users is where the real…

Read More

Navigating the Pulse: A Comprehensive Guide to Mumbai Local Train Commuting and Urban Transit

Few urban experiences match the sheer momentum of Mumbai during peak hours. The city moves to a relentless, rhythmic heartbeat dictated by its suburban railway network, a…

Read More
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x