![]() Mysql -host=127.0.0.1 -port=3306 -user=root -passwordĬreating a database and changing the root password: # Also: -u and -p are shorthand for -user and -password: # log in, prompting for a password (you don't need to specify the -host or -port options for a local login with default settings) SSH tunnel: specify "use SSH tunnel", hostname= yourserver, port=22, username= unixuser, method= password, password= unixpassword).Basic connection: specify hostname=localhost, port=3306, username= databaseuser, password= databasepassword. ![]() or a good client is Navicat (freeware is limited commercial is good can do its own SSH tunnelling). ![]() from another machine: ssh server -L 3306:localhost:3306, and leave the SSH client running once logged in). Data is by default in /var/lib/mysql/ (so a database called "xxx" becomes a directory of that name there, probably with data elsewhere in /var/lib/mysql/ too). It'll ask for a root password during installation.Ĭonfiguration is in /etc/mysql/my.cnf (and /etc/mysql/conf.d/). ![]() Sudo apt-get install mysql-server mysql-client mysql-navigator mysql-admin Based on Ubuntu 10.04 (a variety of Debian Linux). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |