Suggestions on accessible ways to create SQL databases
Submitted by Chuck Winstead on Monday, August 7, 2017.
Forum
macOS & Mac Apps
Hello apple Vis,
I want to work on a few different databases. Does anybody have any suggestions for accessible methods to use sql?
Thanks in Advance.
Chuck
I believe you can also install MySQL and access it from Terminal. Once installed, type
mysql -u root -p
and press enter, then type the root password you configured during setup and press enter again. You're now in the MySQL prompt, and can do anything you like here. CREATE, show, or drop databases, use one and play with tables, manage users, whatever you want. Type quit; (note the semicolon) and press enter to exit back to Terminal.
Agree. If your databases are held on a remote server, you can either ssh to that machine and do anything you like or connfigure the databases to make them support remote management. The former is more secure.
Comments
SQLite3 is available from terminal
You can manage SQLite3 data bases from terminal.
Open Terminal
Type: sqlite3 myDatabase.db
And a new database file named "myDatabase.db" will be created.
sqlite3 environment can use standar SQL language with some limitations.
You can use these commands to get more information or quit the SQLite environment
.exit, .help, .headers, etc
remember: In terminal all commands are case sensitive and remember you have to use special punctuation for some commands.
Regards
MySQL too
I believe you can also install MySQL and access it from Terminal. Once installed, type
mysql -u root -p
and press enter, then type the root password you configured during setup and press enter again. You're now in the MySQL prompt, and can do anything you like here. CREATE, show, or drop databases, use one and play with tables, manage users, whatever you want. Type quit; (note the semicolon) and press enter to exit back to Terminal.
Terminal is your best choice
Agree. If your databases are held on a remote server, you can either ssh to that machine and do anything you like or connfigure the databases to make them support remote management. The former is more secure.