It is a Java application, but very responsive, and you can install both DB drivers and plugins from it, and one of them allows for reverse-engineering and diagramming databases. I am also open to other/easier solutions for this problem. The free SQL tool of choice for me is SQuirreLSQL.
(2) As MAC OS installation of mysql does not have a my.conf file, how the step (4) described above can be performed on my MAC? (1) Are the steps described above are correct and sufficient for my purpose or am I missing something?
#CREATE DATABASE MYSQL MAC OS X HOW TO#
So I do not know how to perform this step on my MAC. However by default, the OS X installation of mysql does not use a my.cnf, and MySQL just uses the default values. From what I have gathered, this means there was some problem in creating the database on the. When I try to create a database, I get the following error: ERROR 1006 (HY000): Can't create database 'SummerGypsydevelopment' (errno: 2. (4) Configure a new MySQL Data Directory: under other OS, for this step we can change my.conf file content by changing the mysqld and client fields values to point to the new directory on external drive. I am trying to set up a dev environment on my Mac laptop, and I have run into some trouble when installing mysql.
(3) Copy all files in MySQL Data Directory to /Volumes/passport/databases by executing cp -R -p /usr/local/mysql/data/ /Volumes/passport/databases (1) Identify Current MySQL Data Directory with -uroot -p -e 'SHOW VARIABLES WHERE Variable_Name LIKE "%dir"' which gets that the datadir path is /usr/local/mysql/data/
After searching for solutions on Web, I plan to do the following: So here is the problem: my hard disk on my Mac (MAC OS High Sierra Version 10.13.6) does not have enough memory and I would like to move my MySQL data directory (mysql-8.0.17) to an external network drive called /Volumes/passport/databases. I saw some solutions related to this problem but I think it still makes sense to ask since nobody mentioned how this can be done in the absence of my.conf file in mysql default installation on MAC OS and also since the most proposed solutions are old.
0 kommentar(er)
