Pinging imac.local with 32 bytes of data: C:\Documents and Settings\Administrator>ping imac.local "Parallels Shared Networking Adapter #0" i tweaked with ip=192.168.123.1įrom WinXP this ip is accessible via ping. Parallels Desktop -> Preferences -> Network -> Shared Network I figured out, how to access shared web-site on the mac. It would be great, when i will be able to access my from Windows, sitting in virtual environment (Parallels). I use Windows XP, installed in Parallels Desktop. The next step is to configure and activate the webserver.I need to test my web site, running on a local Mac, under several browsers in Windows. I repeated the last steps (13.15) for all my other databases. Make sure that the tables will be created by checking the appropriate options in the 'Advanced Settings':ġ6. To be able to transfer tables and data from my current MySQL server into the new server, I had to create a new Connection to the new server inside the current server.Īnd set up the transfer of the old server to the new one: You will have to export the old data to a text file and import it into the new server.ġ4. If the new tables do not have matching character sets, you will not be able to transfer data between the two servers through Navicat. You can examine your table properties withĪnd then click on 'Table Schema' and look for the red-marked text: If you get a window with two pop-ups for the encoding and the collating sequence, choose exactly the same encoding and collating sequence as the tables on your old server have. The default encoding is 'latin1' and the default collating sequence is 'latin1_swedish_ci'. Create the first database and name it the same as the one on your old server:Ī window appears where you can enter the name of the database. You will be get a logon window where you should type the password you just configured for 'root' and click 'OK'.ġ3. That's what Navicat can do for me.ĭouble-click the new connection. To copy all data from my old server to the new Xserve, I have to create the databases manually, but not the tables. For example where the IP-address is from the proxy server that allows access over port 3306.ġ2. When you are going to access MySQL directly from your company's network, you can create a global user with read-only privileges for certain tables. Lasso is a tool to develop web applications, so it should have almost all privileges. Give the Lasso users the privileges you think Lasso needs. If you are going to use Lasso, create two users identical to both root users, and name them and.Give both root users a password and write it down so you do not forget it.Remove both anonymous users (the ones that start with a if you are not going to allow the whole world access to your MySQL Server.Select the new connection by clicking it once and then click the 'Manage Users' button in Navicat's toolbar. The connection shows up in the 'Connections' pane.ġ1. You should get an answer that all's well. Leave the password field blank and click 'Test Connection'. Fill in a nice connection name so you can remember which server it is, enter the IP-address of the new Xserve and as 'User name' type 'root'. You will be presented with the Connection Options window:ġ0. Start Navicat and click the 'Connection' button in the toolbar. I tried some but each time ended up with Navicatĩ. To manage MySQL and its databases there are various tools on the market. Now I should be able to manage MySQL remotely, because the Xserve will be co-located. Open System Preferences and click once on the MySQL icon, located at the bottom of the Preferences :Ĭheck 'Automatically Start MySQL Server on Startup' and click 'Start MySQL Server'. Double click the MySQL.prefpane and select 'Install for all users'.ħ. Double click the MySQLStartupitem installer and follow the instructions.Ħ. Double click the MySQL installer and follow the instructions.ĥ. If the disk does not open after mounting, double click its icon to see its contents.Ĥ. dmg and double click it to manually mount the virtual disk. If Safari is configured to automatically expand downloaded files (this is the default you should turn this option off in Safari's Preferences to have more control over what you download) then you should end up with a mounted virtual disk containing the MySQL installer. Download a MySQL Installer package for Mac OS X.ģ. Within the VNC session, start Safari and browse to. Start and initiate a session with the new Xserve and log in as root.Ģ. Version 4.x is fast enough for me and has, until now, all I need.ġ. Maybe I will install 5 later, when I know it doesn't break anything. There is a version of MySQL 4.1 present in Mac OS X Server 10.4 which you can use (search for MySQL Manager), but I chose to simply install the latest 4.x version. Install MySQL Set up an Xserve from scratch part II
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |