MySQL: Is it possible to give mysql username and password in single line? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 4 years ago.

Improve this question

Can we connect database by terminal by one line. because i'm trying to connect MySQL by terminal from PHP exec(). Here i want to import one MySQL file so i tried following code but it asks password on execution time. so i need help. I want to connect db in one line with username and password.

mysql -u username -p database_name < file.sql

WHY??? You can access a MySQL database from the PHP code direct, much more efficiently and without the complexity of an exec() call — RiggsFolly
– RiggsFolly, Commented Mar 29, 2019 at 9:28
yes but the problem is i need to execute one big .sql file in another database. Here i'm using codeigniter framework. The problem is we are creating that another database in this process only. — D. Surendar
– D. Surendar, Commented Mar 29, 2019 at 9:31
Then import it and execute it line by line. Using exec() is usually a bad idea if you can avoid it. — Qirel
– Qirel, Commented Mar 29, 2019 at 9:37
Possible duplicate of Calling MySQL exe using PHP exec doesn't work — Yassine CHABLI
– Yassine CHABLI, Commented Mar 29, 2019 at 9:38
If it is a big sql file, then access MySQL directly from cli or a proper desktop client, not through php. — Shadow
– Shadow, Commented Mar 29, 2019 at 9:40

StevenTan · Accepted Answer · 2019-03-29 09:51:29Z

3

mysql -h your_host -u your_username -pyour_password -P your_port dbname

-p and your_password without space.

edited Mar 29, 2019 at 9:51

answered Mar 29, 2019 at 9:33

StevenTan

1115 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

D. Surendar Over a year ago

Thank you very much

Promise Preston Over a year ago

This worked for me. Note that -p and your_password are without any space.

Pratikesh · Accepted Answer · 2019-03-29 09:56:53Z

0

Please be careful while doing such kinds of operations. I am giving you one of the solutions to import your database in a single line.

1- Create one configuration file which includes user and password of the database.

[client]user=root password=redhat

2-Fire this command mysql --defaults-extra-file= pathtothenewconfig file [all my other options]

mysql --defaults-extra-file=db.php databasename < /home/pratikesh/Downloads/localdb.sql

Hopes it will works

answered Mar 29, 2019 at 9:56

Pratikesh

121 bronze badge

Collectives™ on Stack Overflow

MySQL: Is it possible to give mysql username and password in single line? [closed]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related