Affordable web design - SETTING UP MYSQL AND PHPMYADMIN Securing MySQL on
SETTING UP MYSQL AND PHPMYADMIN Securing MySQL on Mac OS X Although you have a fully functioning installation of MySQL, by default it has no security. Even if you re the only person working on your computer, you need to set up a similar system of passwords and user accounts as on your hosting company s server. There s one important account that exists by default on all MySQL servers. It s called root, and it is the main database administrator with unlimited powers over database files. When you first install MySQL, access to the root account isn t password-protected, so you need to block this security gap. The MySQL root user, by the way, is totally unrelated to the Mac OS X root user, which is disabled by default. Enabling root for MySQL has no effect on the OS X root user. Setting the MySQL root password If you have just added MySQL to your PATH, you must close and reopen Terminal before embarking on this section. Otherwise, Terminal won t be able to find MySQL. 1. Open Terminal and type the following command: mysql -u root The command contains three elements: mysql: The name of the program -u: Tells the program that you want to log in as a specified user root: The name of the user 2. You should see a welcome message like this: 10 3. The most common problem is getting an error message like this instead: It means that mysqld, the MySQL server, is not running. Use the MySQL control panel in System Preferences to start the server. Another common problem is for Terminal to report command not found. That means you have either mistyped the command or that you haven t added the MySQL program files directory to your PATH, as described in the previous section. 275
In case you need affordable webhost to host your website, our recommendation is ecommerce web host services.