storiessoli.blogg.se - Mysql workbench for mac

#MYSQL WORKBENCH FOR MAC HOW TO#
#MYSQL WORKBENCH FOR MAC MAC OS X#
#MYSQL WORKBENCH FOR MAC INSTALL#

MySQLWorkbench014.png ( 33.3 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench013.png ( 69.8 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench012.png ( 217.1 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench011.png ( 69.5 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench010.png ( 103.4 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench009.png ( 101.4 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench008.png ( 100.9 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench007.png ( 83.4 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench006.png ( 90.8 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench005.png ( 93.8 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench004.png ( 27.0 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench003.png ( 95.3 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench002.png ( 115.8 KB) - added by BjarneDMat 11 years ago.

MySQLWorkbench001.png ( 204.3 KB) - added by BjarneDMat 11 years ago.

Optional Parts TODO: What else can be done?

#MYSQL WORKBENCH FOR MAC INSTALL#

Reload privilege tables now? Y # make sure the above settings are appliedĬonfiguration Step 1: Install MySQL Workbenchĭownload and install the MySQL Workbench program from MySQL Workbench Step 2: Modify the default settings in MySQL WorkBench Remove test database and access to it? Y # we have no need for a test database Remove anonymous users? Y # anonymous users are not wanted !ĭisallow root login remotely? Y # root can only log in from localhost New password: # enter at very secure password

Set root password? Y # we do want the root user to have a password The following are the questions asked by mysql_secure_installation and the appropriate answersĮnter current password for root (enter for none): # just hit as the database is new # MySQL Workbench read the file as the current user macports/lib/mysql5/bin/mysql_secure_installation # secure the default installationĮcho '' > /macports/etc/mysql5/my.cnf # create a very basic configuration file for mysql(d)Ĭhown _mysql:_mysql /macports/etc/mysql5/my.cnfĬhmod 664 /macports/etc/mysql5/my.cnf # I'ld have preferred 660, but that conflicts with letting Ps -axj | grep mysql # check that the mysql server is running Port load mysql5 # start the mysqld server Mysql_install_db5 -user=_mysql # install the default databases # + so we'll have to be somewhere in the file system where Installation Step 1: Install and configure the mysql5 port port install mysql5-server # install mysql5 from macportsĬd /private/tmp # the following command is executed as the _mysql user Many web-interfaces / web-services require a basic setup in the MySQL database in order to do their own configuration stuff.

#MYSQL WORKBENCH FOR MAC HOW TO#

This tutorial shows how to modify the default setting to get it to recognize the MacPorts install of MySQL5 as well as giving a very basic introduction in setting up a basic configuration that the postfixadmin port can use.

#MYSQL WORKBENCH FOR MAC MAC OS X#

The MySQL Workbench program make some assumptions as to where files are under Mac OS X - specifically the program assumes that MySQL has been installed from the *.dmg downloaded from MySQL. It's basically a GUI frontend to the mysql client and as such is similiar to the phpMyAdmin web-frontend. MySQL Workbench is a nice and advanced GUI frontend to administer MySQL databases. You'll have to substitute with /opt/local/. I'm custom-installing MacPorts in /macports instead of /opt/local