I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key.
I am trying to connect to a remote MySQL database in Bash. On the server hosting the database I can type:
mysql -u username -p
to connect.
I would like to be able to type:
mysql -h host -u username -p
to connect from another server. I don't have MySQL installed on the client so the command is not found.
I originally installed mySQL on OSX and it started fine. I was able to connect with mySQL workbench and create a database. However, after a reboot mySQL will no longer start.
How do I create a local backup of a remote Amazon RDS MySQL database? What I need to know is how to make a complete full local backup of a MySQL database (not a remote Amazon snapshot) that can be used to restore to a new database anywhere, on any MySQL server (same version of course).
NOTE: I know how to import data from a flat file via MySQL.
in Mysql-Workbench,i clicked on open connection to start querying and i get a dialog where i get the hostname,username,password,etc...
in hostname it has 127.0.0.1, user set as root, and i've enter the root password for mysql and i get this:
Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
Lost connection to MySQL serve
I've got MySQL Connector/ODBC 5.1 installed on my Windows Vista laptop. I have MySQL 5.5.19 installed on the laptop, and was able to connect to it via the Windows Data Source Administrator app and the MySQL Connector/ODBC using a TCP/IP connection to 'localhost'.
I am trying to crate a shell script that would:
connect to a remote server that has MYSQL running
On success run "CREATE DATABASE foo;"
So far I tried:
#!/bin/bash
mysql -h 111.11.11.11 -u root -p'XXXXXXX'
mysql> CREATE DATABASE foo;
or
echo "CREATE DATABASE foo;";
But no success.
I am using the command line to run the shell script.
# sh create_mysql_database.sh
but all it does is
I am building two mysql machines in master-slave config.
My server hangs everyday
So i checked system health - process manager in whm
there was a command given below
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306
see this image
here this mysql command process is taking
Email this page
