Jan 20, 2012 · use the MySQL command line client: mysql -h hostname -u user database < path/to/test.sql; Install the MySQL GUI tools and open your SQL file, then execute it; Use phpmysql if the database is available via your webserver

You need to use the -p flag to send a password. And it's tricky because you must have no space between -p and the password. If you use a space after -p it makes the mysql client prompt you interactively for the password, and then it interprets the next command argument as a …

Jul 30, 2016 · How can I execute remote MySQL queries via shell script without putting open text password in my shell script?

May 23, 2015 · The mysql client utility can take a password on the command line with either the -p or --password= options. If you use -p , there must not be any blank space after the option letter: $ mysql -pmypassword

Sep 23, 2018 · mysql -u root -p --execute="SELECT User, Host FROM mysql.user" prompts for a password, executes the given command, and returns to the shell (no logout required). If you instead want your own prompt you need to script it:

Oct 5, 2017 · Similar to Stéphane Chazelas answer, you can create a .my.cnf inside the home of the user you're using to execute the script, add your credentials and just execute your script. ~/.my.cnf. script. From man mysql. Execute the statement and quit. The default output format is like that produced with --batch. See Section 4.2.4, “Using.

Using mysql is very easy. Invoke it from the prompt of your command interpreter as follows: Or: In this case, you'll need to enter your password in response to the prompt that mysql displays: Then type an SQL statement, end it with ;, \g, or \G and press Enter.

Sep 9, 2015 · The syntax is as follows for both MariaDB and MySQL client: mysql -u user -p -e 'Your SQL Query Here' database-name. OR. mysql -u USER -p PASSWORD -h MYSQLSERVERNAME -e 'select * from foo...' database-name. Where,-u : Specify mysql database user name-p: Prompt for password-e : Execute sql query; database: Specify database name; Examples

Jan 19, 2025 · Understanding the Code Example: Running SQL Scripts in MySQL. While there isn't a specific programming language code to "run" a SQL script, we can explore how to execute SQL scripts within different programming contexts. Command-Line Interface (CLI) mysql -u username -p database_name < script_name.sql

Nov 2, 2021 · First, you need to connect to your MySQL database server using the mysql command. Here’s an example of connecting with the root user: Next, enter the password for your root user. Once inside, use the source or \. command followed by the absolute path to the SQL file as shown below: # or mysql> \. /Users/nsebhastian/Desktop/test/main.sql.