Search Results

$ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 How can I monitor its …

I'm trying to start the server and then fix the root user by $ mysql -u root mysql $mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root'; $mysql> FLUSH PRIVILEGES; But the server … : mysql Ver 14.14 Distrib 5.6.21, for osx10.8 (x86_64) using EditLine wrapper Permissions: $ ls -la /usr/local/mysql-5.6.21-osx10.8-x86_64 total 232 drwxr-xr-x 17 qazwsx wheel 578 Oct 20 23 …

What's the fastest way to replicate a MySQL database from one machine to another? The two machines are connected via LAN. How to do it without mysqldump? … If using mysqldump, is the fastest way $ mysqldump -h localhost -u foo -pbar mydb > mydb.sql and then copy mydb.sql to desination machine and do $ mysql -h localhost -u foo -pbar < mydb.sql ? …

Starting MySQL database server $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) And $ mysqladmin ping /usr/local/mysql/bin/mysqladmin: connect to … skip-grant-tables Starting MySQL database server $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) $ sudo ls -l /usr/local/mysql/data/*.err Password: …

How to set datadir to different values based on the hostname in my.cnf? I want to use the same my.cnf file on a Linux machine and a Mac OS X machine where the datadir should have different values.

I installed MySQL Community Server following instructions at http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html with the Startup Item and the MySQL Preference Pane. … Every time when I try to stop the sever using System Preference -> MySQL -> Stop MySQL Server, it hangs. I will need to force quit the System Preference from the dock. …

mysql> select user, password, host from user; +------+----------+---------------------------------------------+ | user | password | host | +------+----------+---- … server on my machine using $ mysql mysql> select user(); +----------------+ | user() | +----------------+ | qaz@localhost | +----------------+ 1 row in set (0.00 sec) So why qaz doesn't exist …

In MySQL, how to manually edit values of a BLOB column in few tuples? …

How to install MySQL server on Mac (OS X 10.6.8) from command line? If I donwload the .dmg file, is it possible to install it from command line? …

http://dev.mysql.com/downloads/utilities/ has MySQL Utilities 1.4.4 for Mac OS X 10.7. Is this still updated and recommended to use along with MySQL Workbench? … I'm at the latest MySQL Workbench 6.1 CE on Mac OS X 10.9.2. …

But I just couldn't get it to work with IF THEN ELSE statement in MySQL. What should be the right syntax? …

For MySQL, how to INSERT the result of a SELECT statement? … col1, @input2 AS col2 WHERE @input1 > 0 AND @input2 > 0; which gives a message: [42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL …

Upon running a .sql file for creating a schema in MySQL Workbench 6.1, it prompts a window saying it cannot decide the right character set What's the proper thing to do? …