![]() Click the plus sign at the bottom (the one to the left of the minus sign).Set the type to VARCHAR and give it a length of 200. Click the plus sign right above the word INDEXES and name the field message.Then click the plus sign at the bottom left to create a new table.Click Choose Database… at the top left followed by Add Database….Enter root for the Username and newpassword for the Password. Go through the installation, open Sequel Pro, and enter 127.0.0.1 for the Host.This is like phpMyAdmin, but better because it’s a desktop app. Type ALTER USER IDENTIFIED BY 'newpassword' and press enter.Then it says Enter Password: which is 8hxKsiIh?YMt for me (you should use the password you copied earlier instead of 8hxKsiIh?YMt).This is the password you use when you login to your Mac When you press enter it will ask you for your Password.Go back to Terminal and type sudo /usr/local/mysql/bin/mysql -u root -p.Press Start MySQL Server to turn it on and you’ll see:.Click on MySQL and you’ll see that it’s turned off.Press the Apple logo at the top left of your screen and go to System Preferences. ![]() Do this now, as it will be pain to reset the password if you don't know it. Copy the password to text file (or take a screenshot) and press okay.
0 Comments
Leave a Reply. |