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? #How to configure mysql on mac installReload 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. #How to configure mysql on mac how toThis 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. #How to configure mysql on mac mac os xThe 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |