I'm looking for a tool to compare data between two MySQL servers/databases I see the MySQL Workbench has a "synchronization" option ([link](https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html)) , but it doesn't actually say what they mean by "synchronizing". Does the tool just synchronize the schemas (table structures) or does it also synchronize the actual data in the tables?

I want to set user password of length more than 32 characters. But got an error password is too long . Is there any settings that I can change and use long password? I'm using MAMP PRO 4.4.1, MySQL 5.6.38 on mac os High Sierra

I'm trying to automate some MySQL Workbench connection creation/modification from a bash (or NodeJS) script running on OSX. However, whenever I update the connections.xml file and the Keychain access entry, then open the connection details in Workbench, it just reverts the connections.xml file back to what it was before. I have full access to OSX Keychain Access, and I can see/update/create the keys in there just fine. I can also see the connections in the MySQL workbench connections file (~/Library/Application Support/MySQL/Workbench/connections.xml). I'm trying to update the username and password for a connection to a specified server, but when I update it in the connections.xml and OSX Keychain, it doesn't actually change it in the MySQL workbench UI. Moreover, when I close out of the connection details for that server, it automatically reverts the connections.xml file back to what it was before. I've been looking around in the Python scripts in the MySQL/Workbench directory and it looks like it creates a temporary file, but I can't find where that file is located at. I'm also not sure if updating that would work either (I have a feeling it might just crash Workbench).

I am having an issue with running a script within a python virtual environment. I have installed MySQL, MySQL client, Django, and everything using Homebrew since I am on a Mac M1 (Apple M1 Pro running Sonoma 14.4). When I double-check this using pip install, I always get a requirement satisfied message. Also, I have no issues starting up a database within MySQL and accessing this database. I have seen some information that this is a version error, but uninstalling and re-installing MySQL with arch arm64 brew install mysql provides the same errors as above. I have also seen some information saying to install just the specific library that is missing, but I am not sure which one that is in this case. This is the complete error I am getting:

Traceback (most recent call last):
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/db/backends/mysql/base.py", line 15, in 
    import MySQLdb as Database
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/MySQLdb/__init__.py", line 17, in 
    from . import _mysql
ImportError: dlopen(/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/MySQLdb/_mysql.cpython-312-darwin.so, 0x0002): symbol not found in flat namespace '_mysql_affected_rows'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/giuseppespartico/Desktop/jrc-folder/kcb-ds/./manage.py", line 21, in 
    main()
  File "/Users/giuseppespartico/Desktop/jrc-folder/kcb-ds/./manage.py", line 17, in main
    execute_from_command_line(sys.argv)
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/core/management/__init__.py", line 416, in execute
    django.setup()
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/__init__.py", line 24, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/apps/registry.py", line 116, in populate
    app_config.import_models()
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/apps/config.py", line 269, in import_models
    self.models_module = import_module(models_module_name)
                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/importlib/__init__.py", line 90, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "", line 1387, in _gcd_import
  File "", line 1360, in _find_and_load
  File "", line 1331, in _find_and_load_unlocked
  File "", line 935, in _load_unlocked
  File "", line 995, in exec_module
  File "", line 488, in _call_with_frames_removed
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/contrib/auth/models.py", line 3, in 
    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/contrib/auth/base_user.py", line 57, in 
    class AbstractBaseUser(models.Model):
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/db/models/base.py", line 143, in __new__
    new_class.add_to_class("_meta", Options(meta, app_label))
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/db/models/base.py", line 371, in add_to_class
    value.contribute_to_class(cls, name)
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/db/models/options.py", line 243, in contribute_to_class
    self.db_table, connection.ops.max_name_length()
                   ^^^^^^^^^^^^^^
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/utils/connection.py", line 15, in __getattr__
    return getattr(self._connections[self._alias], item)
                   ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/utils/connection.py", line 62, in __getitem__
    conn = self.create_connection(alias)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/db/utils.py", line 193, in create_connection
    backend = load_backend(db["ENGINE"])
              ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/db/utils.py", line 113, in load_backend
    return import_module("%s.base" % backend_name)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/importlib/__init__.py", line 90, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/giuseppespartico/Desktop/jrc-folder/biomonenv/lib/python3.12/site-packages/django/db/backends/mysql/base.py", line 17, in 
    raise ImproperlyConfigured(
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.
Did you install mysqlclient?

Does anyone know how to fix this?

The "MySQL" client interface library will not load on MacOS Monterey. The relevant traceback lines are as follows: *(System is Django, latest versions of everything.)* ImportError: dlopen(/Users/mike/.virtualenvs/djangoprod/lib/python3.11/site-packages/MySQLdb/_mysql.cpython-311-darwin.so, 0x0002): Library not loaded: '@rpath/libmysqlclient.21.dylib' Referenced from: '/Users/mike/.virtualenvs/djangoprod/lib/python3.11/site-packages/MySQLdb/_mysql.cpython-311-darwin.so' Reason: tried: '/usr/lib/libmysqlclient.21.dylib' (no such file) It seems to me that Python is trying to use @rpath to find the library, and man dyld explains to me just what that is. So far, so good ... I have specified export DYLD_LIBRARY_PATH=/usr/local/mysql-8.0.31-macos12-X86_64/lib, which *is* the correct location, but the library is still not being found. (Notice from the tail of line #2 that it appears to be using @rpath *explicitly* as part of the library path being searched.) I have read other unrelated forum postings which provide DYLD_LIBRARY_PATH as a solution, albeit in the Linux environment. I don't know how to actually *see* what @rpath contains. I do know that "this used to work," but it's been a while since I had anything to do with this application and I frankly don't recall which MacOS version I was using at that time. Is it possible that "System Integrity Protection" has anything to do with this? I read that in certain cases that it blocks this environment variable, but it is not entirely clear to me when it does and doesn't apply. The Python3 interpreter in question is located in a "virtual environment" which means that it is actually running out of a user-local directory which therefore would not be covered by SIP. But the libraries themselves do reside in /usr, which is. I did rebuild that virtual environment.

I've been trying for ages to get this to work. Standard Homebrew recipe does not include MySQL support. I've tried: brew edit dovecot and added --with-mysql to the args section but it just seems to download the standard version without mysql support:

% brew install --build-from-source dovecot 

==> Fetching dovecot
######################################################################## 100.0%
==> Downloading https://raw.githubusercontent.com/Homebrew/formula-patches/03cf8088210822aa2c1ab544ed58ea04c897d9c4/libtool/configure-big_sur.diff 
######################################################################## 100.0%
==> Downloading https://raw.githubusercontent.com/Homebrew/formula-patches/03cf8088210822aa2c1ab544ed58ea04c897d9c4/libtool/configure-big_sur.diff 
Already downloaded: /Users/jlbrown/Library/Caches/Homebrew/downloads/195208ba31cadc265ea97bb8aad4e78caab1200daf4d855e6c839b5f987f92db--configure-big_sur.diff
==> Downloading https://pigeonhole.dovecot.org/releases/2.3/dovecot-2.3-pigeonhole-0.5.20.tar.gz 
######################################################################## 100.0%
==> Downloading https://dovecot.org/releases/2.3/dovecot-2.3.20.tar.gz 
Already downloaded: /Users/jlbrown/Library/Caches/Homebrew/downloads/b9e612337caea98cfb0c508b92ac69cb54c02769a6cc7d768e0bb9841c67dff3--dovecot-2.3.20.tar.gz
==> Patching
==> Applying configure-big_sur.diff
patching file configure

==> ./configure --prefix=/opt/homebrew/Cellar/dovecot/2.3.20 --libexecdir=/opt/homebrew/Cellar/dovecot/2.3.20/libexec --sysconfdir=/opt/homebrew/etc --localstatedir=/opt/homebrew/var --with-bzlib --with-pam --with-sqlite --with-ssl=openSSL

==> make install
==> Patching pigeonhole

==> Applying configure-big_sur.diff
patching file configure
==> ./configure --with-dovecot=/opt/homebrew/Cellar/dovecot/2.3.20/lib/dovecot --prefix=/opt/homebrew/Cellar/dovecot/2.3.20
==> make
==> make install
==> Caveats
For Dovecot to work, you may need to create a dovecot user
and group depending on your configuration file options.

To restart dovecot after an upgrade:

  sudo brew services restart dovecot
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/dovecot/sbin/dovecot -F
==> Summary
🍺  /opt/homebrew/Cellar/dovecot/2.3.20: 1,236 files, 30.4MB, built in 2 minutes 38 seconds


Feb 21 15:22:38 master: Info: Dovecot v2.3.20 (80a5ac675d) starting up
 for imap, pop3 (core dumps disabled) Feb 21 15:22:47 auth: Fatal: sql:
 Unknown database driver 'mysql'

Disparate for a solution! Running on Ventura (macOS 13.2.1) on a M1 Mac

I installed MySQL on my Mac, and now I would like to add it to my $PATH variable. I want to be able to type mysql anywhere. I tried adding the following to my .profile file: export PATH=${PATH}/usr/local/mysql/bin/ I have restarted my Terminal but it does not do the trick. It still says: -bash: mysql: command not found. How can I add this properly to my $PATH? I am using OS X Yosemite.

I used brew update brew upgrade mysql to bump version from 8.0.23 to 8.0.26 and now MySQL service won't start anymore. I try brew services start mysql and after few seconds the service status goes back to stopped. The last line in .err files in /usr/local/var/mysql says

[ERROR] [MY-010123] [Server] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

And when I delete the .err files they come back as owned by root. They were not owned by root before. My current user is not root and I do not use sudo to run these commands. Why is this happening and how do I fix it?

If I run console on my mac and go to the system.log I see that system,log is getting flooded with this error Oct 31 15:57:59 abhisheks-mbp com.apple.xpc.launchd (homebrew.mxcl.mysql): Service could not initialize: Unable to set current working directory. error = 2: No such file or directory, path = /usr/local/var/mysql: 17A405: xpcproxy + 11040 [43FABD4F-8081-3087-91BC-95B588688D55]: 0x2 Oct 31 15:57:59 abhisheks-mbp com.apple.xpc.launchd (homebrew.mxcl.mysql): Service only ran for 0 seconds. Pushing respawn out by 10 seconds. Oct 31 15:58:03 abhisheks-mbp com.apple.xpc.launchd (com.apple.preference.displays.MirrorDisplays): Service only ran for 0 seconds. Pushing respawn out by 10 seconds. I had installed mysql using homebrew many months ago. but I had removed it I don't know why its still trying to run it. I tried to remove mysql ~ > brew uninstall mysql Error: No such keg: /usr/local/Cellar/mysql But still i see messages pouring in.

System messages are showing repeated

Dec 25 14:42:02 ROLANDs-MacBook-Pro com.apple.xpc.launchd (com.mysql.mysqld): Service only ran for 0 seconds. Pushing respawn out by 10 seconds.

every one of two seconds. I think this is being started by com.oracle.oss.mysql.mysqld. Using 'sudo launchctl remove' on both of these doesn't seem to work as after a restart they're both back, so there must be something else happening (Murphy Corollary: before you can do anything, there's something else you have to do first). I have MySQL mysql-5.7.25-macos10.14-x86_64 loaded on the my Macbook Pro and in System Preferences it's being started on bootup. How do I fix this issue ... I'd like to upgrade, but don't want to take this problem forward with the upgrade. Thanks! Roland

I've been through every how-to I can find on the internet, but none are working for me. I've got a fresh install of MySQL 5.7 via homebrew. I can see that the service is running, and the mysql client is installed as well. Any attempt to get to the database via the client, like mysql -u root -p or more simply mysql -u root as the installation process suggests, asks for a password with the prompt "Enter password:". Well, I just installed the database; I have no idea what the password is. Using sudo makes no difference. I've tried solutions involving mysqladmin with essentially the same result: "Access denied for user 'root'@'localhost'". I've got a bunch of experience with Postgresql, but it's got a significantly different way of dealing with mapping platform identity to db identity apparently. How do I get this thing to work? (Note that the many answers in Ask Different are among the ones I've tried already with the exact same problem.)

How to entirely delete MySQL from mac Monterey 12.5.1? I read articles about this. In all articles it's written that you should go to "System Preferences" -> "MySql" and you will get this window However, when I click on "MySql" in "System Preferences" window, it pops out like this There is no "uninstall" button and I do not have MySql application in the "Application" folder. P.S. in my case, the MySql icon looks like a gear, not a dolphin.

Can any one please let me know how to create new user and new db in MySQL? How to use mysqladmin in Mac OS X?

I upgrade my OSX to 12.4. after that my brew mysql don't start. I got: $ brew services start mysql Bootstrap failed: 5: Input/output error Try re-running the command as root for richer errors. Error: Failure while executing; /bin/launchctl bootstrap gui/501 /Users/gerd/Library/LaunchAgents/homebrew.mxcl.mysql.plist exited with 5. I think it's a permission problem. The brew mysql stop by root on upgrade to 12.4 brew services list Name Status User File mysql stopped root ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

I am trying to set up a development environment on my new MacBookPro 14 inch M1 Pro. I am using MacPorts because that is what I have used for many years. Setting up apache and php have mostly just worked, with only a minimal amount of tweaks. But setting up the database gives lots of different kinds of errors. So I am wondering if it could be a Monterey problem or an Apple Silicon problem. I have tried mariadb-10.6, mariadb-10.5 (just to see if that would work), and even mysql8. They all give different errors, which might be related to permissions. I was under the impression that the Macports installs should "just work". But there are error messages that should be helpful. So I uninstalled all the databases and started over so I could capture the error messages. Here is what I get: jas@himalaya2 ~ % sudo -u _mysql /opt/local/lib/mariadb-10.6/bin/mysql_install_db Password: shell-init: error retrieving current directory: getcwd: cannot access parent directories: Permission denied job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied Installing MariaDB/MySQL system tables in '/opt/local/var/db/mariadb-10.6' ... job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied /opt/local/lib/mariadb-10.6/bin/mysql_install_db: line 525: 71810 Abort trap: 6 "$mysqld_bootstrap" $defaults $defaults_group_suffix "$mysqld_opt" --bootstrap $silent_startup "--basedir=$basedir" "--datadir=$ldata" --log-warnings=0 --enforce-storage-engine="" "--plugin-dir=${plugindir}" $args --max_allowed_packet=8M --net_buffer_length=16K job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied Installation of system tables failed! Examine the logs in /opt/local/var/db/mariadb-10.6 for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /opt/local/lib/mariadb-10.6/bin/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /opt/local/lib/mariadb-10.6/bin/mariadbd --skip-grant-tables --general-log & and use the command line tool /opt/local/lib/mariadb-10.6/bin/mariadb to connect to the mysql database and look at the grant tables: shell> /opt/local/lib/mariadb-10.6/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in /opt/local/var/db/mariadb-10.6 that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db You can find the latest source at https://downloads.mariadb.org and the maria-discuss email list at https://launchpad.net/~maria-discuss Please check all of the above before submitting a bug report at https://mariadb.org/jira jas@himalaya2 ~ % So you can see why I say there is a permissions issue. At this point, looks like some major failures. Looking at the logs as advised is no help because the only log files there are not text files: jas@himalaya2 ~ % cd /opt/local/var/db/mariadb-10.6 jas@himalaya2 mariadb-10.6 % ls aria_log.00000001 ib_logfile0 mysql aria_log_control ibdata1 ddl_recovery.log ibtmp1 jas@himalaya2 mariadb-10.6 % Also trying to start without the grant tables gives yet more errors that seem to be permissions errors. And there are no other my.cnf files on the system, so that hint is no help either. So why does the plain vanilla steps I have take lead to all these issues? Monterey?

Since a couple days I cannot connect to several mysql instances when using SSL. I am quite sure it's a problem on my machine, since colleagues and production servers don't have this issue. In both my Python clients and the mysql command line client I get an error. See this example when using the mysql CLI:

$ mysql -h blablabla.eu-central-1.rds.amazonaws.com -D dbname -U username
ERROR 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol

I think there is something wrong with my SSL settings, openssl, certificates, ... Well as you can guess from the options, I don't understand enough about this to pinpoint the problem :)

I am trying to install SQL Server on m1 based Mac with docker https://debugsolutions.wordpress.com/2021/03/17/using-sql-server-on-m1-based-mac-with-docker/ I made it all the way to end of step 5, but my container won't connect. I am getting:

1/08/02 01:31:47 [launchpadd] INFO: Launchpadd is connecting to mssql on localhost:1431
2021/08/02 01:31:47 [launchpadd] WARNING: Failed to connect to SQL because: dial tcp 127.0.0.1:1431: connect: connection refused, will reattempt connection.
2021/08/02 01:31:48 [launchpadd] WARNING: Failed to connect to SQL because: dial tcp 127.0.0.1:1431: connect: connection refused, will reattempt connection.
2021/08/02 01:31:49 [launchpadd] WARNING: Failed to connect to SQL because: dial tcp 127.0.0.1:1431: connect: connection refused, will reattempt connection.
2021/08/02 01:32:41 [launchpadd] INFO: Extensibility Log Header:
2021/08/02 01:32:41 [launchpadd] WARNING: Failed to load /var/opt/mssql/mssql.conf ini file with error open /var/opt/mssql/mssql.conf: no such file or directory
2021/08/02 01:32:41 [launchpadd] INFO: DataDirectories = /bin:/etc:/lib:/lib32:/lib64:/sbin:/usr/bin:/usr/include:/usr/lib:/usr/lib32:/usr/lib64:/usr/libexec/gcc:/usr/sbin:/usr/share:/var/lib:/opt/microsoft:/opt/mssql-extensibility:/opt/mssql/mlservices:/opt/mssql/lib/zulu-jre-11:/opt/mssql-tools
2021/08/02 01:32:41 Drop permitted effective capabilities.
2021/08/02 01:32:41 [launchpadd] INFO: Polybase remote hadoop bridge disabled
2021/08/02 01:32:41 [launchpadd] INFO: Launchpadd is connecting to mssql on localhost:1431
2021/08/02 01:32:41 [launchpadd] WARNING: Failed to connect to SQL because: dial tcp 127.0.0.1:1431: connect: connection refused, will reattempt connection.
2021/08/02 01:32:42 [launchpadd] WARNING: Failed to connect to SQL because: dial tcp 127.0.0.1:1431: connect: connection refused, will reattempt connection.
2021/08/02 01:32:43 [launchpadd] WARNING: Failed to connect to SQL because: dial tcp 127.0.0.1:1431: connect: connection refused, will reattempt connection.

How can I fix this? The command I ran at end of step 5

docker run --cap-add SYS_PTRACE -e ‘ACCEPT_EULA=1’ -e ‘MSSQL_SA_PASSWORD=Password.1’ -p 1433:1433 --name azuresqledge -d mcr.microsoft.com/azure-sql-edge

Hello I have installed Homebrew versions of Apache, PHP and MYSQL on Monterey, however I am experiencing some issues when restoring a database which was created on another "pure" MySQL server. The custom tool which is used to restore the database on my Mac, will throw warnings concerning inconsistencies on the (restore) database server: > STATUS character set and collation isn't supported on current > database. "Legacy Character set" and "Legacy Collation" will be > replaced with default values. DETAILS This test checks to make sure > this database can support the character set and collations found in > the dup-installer/dup-database__[HASH].sql script. > > Character set list utf8 utf8mb4 Collations list latin1_general_ci > utf8_general_ci utf8_unicode_ci utf8mb4_unicode_520_ci > utf8mb4_unicode_ci The database where the package was created has a > character set and collation that is not supported on this server. This > issue happens when a site is moved from an newer version of MySQL to a > older version of MySQL. The recommended fix is to update MySQL on this > server to support the character set that is failing below. If this is > not an option for your host, then you can continue the installation. > Invalid values will be replaced with the default values. For more > details about this issue and other details regarding this issue see > the FAQ link below. > > Default charset and setting in current installation DB_CHARSET = > utf8mb4 DB_COLLATE = utf8mb4_general_ci So I have verified MySQL version which was used to backup: And and restore version: I wonder if this issue is due to inconsistent character set and collating sequence (can this be fixed somehow?) or if the issues are due to MariaDB on the receiving end?

I have installed MySQL via homebrew : brew install mysql. I'd like to get the MySQL preference pane hooked up to my installation of MySQL through homebrew. How can I achieve this?

So I've tried installing mariadb and using the mysql command but I always get the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) If I uninstall mariadb and try using mysql I get: command not found: mysql If I then do ps ax | grep mysql I get this: 7809 s000 S+ 0:00.00 grep --color=auto --exclude-dir=.bzr --exclude-dir=CVS --exclude-dir=.git --exclude-dir=.hg --exclude-dir=.svn --exclude-dir=.idea --exclude-dir=.tox mysql If I try killing it with the PID 7809 (This ID is changing every single time I run the command) I get this: kill 7809 failed: no such process I've deleted every single folder using this tutorial but it didn't help. I don't have mysql in my mac system preferences so I can't uninstall it there. I have no clue what else to try. I also tried all kinds of Launchctl unloading but mostly I just get this error: Unload failed: 5: Input/output error Every time I restart my mac and check what processes are running mysql is always there. Did anyone experience something similiar?