Breaking News: Grepper is joining You.com. Read the official announcement!

command line mysql xampp

Add Answer

Smiling Swan answered on May 29, 2021 Popularity 10/10 Helpfulness 5/10

answer command line mysql xampp

related mysql command line xampp ubuntu

related connect xampp mysql on cmd windows

command line mysql xampp

Comment

cd c:\xampp\mysql\bin
mysql.exe -u root --password

Popularity 10/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: command-line mysql sql xampp

Link to this answer
Share Copy Link

Contributed on May 29 2021

Smiling Swan

0 Answers Avg Quality 2/10

Closely Related Answers

mysql command line xampp ubuntu

Comment

/opt/lampp/bin/mysql -u root

Popularity 9/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: command-line command-li

Link to this answer
Share Copy Link

Contributed on May 29 2021

Smiling Swan

0 Answers Avg Quality 2/10

connect xampp mysql on cmd windows

Comment

To access SQL via the command line we simply navigate to the xampp folder. the folder is usually on the c:\ drive.

type: cd c:\xampp\mysql\bin then press enter.
type: in mysql -u root -p then press enter.
in the new line enter the password of the database.
type: show databases; to see all the databases that you have access to.
once you know what database you want to use type (ex. cms_database), type use cms_data or any other db_name, it should say Database changed
// Bonus Note you shouldn't use the root user when working with databases. you would want to create a separate account (ex. cms_user) with special privileges to limit errors.

to do that type:

GRANT ALL PRIVILEGES IN cms_database.*
TO 'cms_user'@'localhost' 
IDENTITIED BY 'yourpassword'
double check by using the command:

SHOW GRANT FOR 'cms_user'@localhost;
if you already have the name of the user and the specific database you wish to use, change step 2 to this.

mysql -u cms_user -p cms_database

Popularity 9/10 Helpfulness 6/10 Language sql

Source: stackoverflow.com

Tags: cmd

Link to this answer
Share Copy Link

Contributed on Oct 18 2022

Rehman

0 Answers Avg Quality 2/10

command line mysql xampp

Contents

More Related Answers

command line mysql xampp

Closely Related Answers

mysql command line xampp ubuntu

connect xampp mysql on cmd windows

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.