I of course have a db, first_db, already created and am able to interact w/ it from the mysql prompt I just need help using mysql scripts. Also, it comes with the most popular web scripts & operating system templates.
#HOSTBUDDY MYSQL SCRIPTS INSTALL#
Our VPS trial hosting plans included with a developer-friendly auto-installer. This post contains files that may install malware or run destructive scripts on your computer. If no hostname is specified then it assumes that you are trying to make a connection to the localhost (or 127.0.0.1) For connecting to a remote host, you can mention the host IP or hostname using the ‘-h’ command. Linux VPS installs the Linux operating system in. INSERT INTO Department (name) VALUES ("Fire") Answer: MySQL command line provides the flexibility of connecting to a server on a remote host as well as local host.
Here's my script: USE first_db ĬREATE TABLE Department(id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,ĬREATE TABLE Employees(id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, I don't think there's anything wrong with my script since I can run the commands individually from the mysql prompt. I know this means the file could not be found or supposedly does not exist yet from my explorer I right clicked on the file to get info on its path so I think the path is okay. I get Failed to open file '/home/ryan/MYSQL Scripts/test.sql', error: 2
Mysql>SOURCE /home/ryan/MYSQL_Scripts/test.sql If I put the wrong password I get an error and if I put the correct password nothing happens, the terminal behaves as if its expecting further input. step 1: Go to file - click open sql script- Run it.
Then I run mysql -u root -p > test.mysql and it asks me for my password. Mysql workbench 6.0 provides easy interface to import and run or execute. What I can't do is write an sql file and run it.įrom a regular terminal I change into the directory containing my script test.sql I can create a db, add tables, add rows to tables, get queries etc. I'm using Ubuntu 16.04 and I'm able to use MySql from the command line fine. Please note we will close your issue without comment if you delete, do not read or do not fill out the issue checklist below and provide ALL the requested information.
0 kommentar(er)
