![]() ![]() ![]() My first time with local server db connection and first time on mac. In websites with a lot of traffic and data, you might even need to increase the value to 1024M. Where the phisical database DB.mwb should be stored? under /htdocs/? or under the WebRatio folder and I should specify the path in the connection somewhere? or else the connectionDB creates it automatically somewhere? If not, try increase the 128M values to 256M for example. Then the last step is to restart the MySql server. if your Local Ip address changes randomly then use bind-address 0.0.0.0. Some questions to understand the logic of a connection: vi /etc/mysql/my.cnf In the file, search for the mysqld section block and add the new bind address bind-address 127.0.0.1 comment it and add your Ip address. save the file and restart mysql server by typing the following command in your terminal. Now, with both server and connection running, I entered the string jdbc:mysql://127.0.0.1:8889/connectionDB but it doestn't connect on refresh (only using jdbc:mysql://127.0.0.1:8889/ works). jugal have you checked that your MySQL Mamp server is running in localhost:3306 You could check if anything else is trying to run on that port. In my experience the password usually is left blank: password. With Sequel Pro I created a standard TCP/IP connection named connectionDB and it seems properly running on 127.0.01:8889 (root as username and password). your problem might be in the connection parameters, you are setting your password: root. The contents of the file may seem complicated in understanding, but. As a text editor, I use the TextEdit app, but you can use any other editor. In the Finder, go to the folder Applications MAMP bin phpMyAdmin. The server properly run under /127.0.0.1:8889 (checked) and the local folder is /MAMP/htdocs/ If the MAMP app is running, click the Stop Servers button and quit the app. I am a mac user (newbie indeed.) I downloaded MAMP and started the local mysql. I am trying to connect through JDBC a DB.mwb under mysql (MAMP).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |