6/17/2023 0 Comments Mamp phpmyadmin![]() Type that name in this field and then click the 'Create' button just below it. If you want to have a local machine version of your live site I suggest that you use the same database name as your live site. This is where you want to put the name of your MySQL database. Just a little further down it says 'Create new database' with a field below it. My page has a heading in the body of the page that says 'MySQL - 4.1.12'. ![]() This brings you to a page where you can create a database in MySQL in your MAMP environment. The URL for the MAMPpage will be Once you are back on the 'Welcome to MAMP' page click on the ' phpMyAdmin' link on the page. Don't lose this installation page, either go to your 'Welcome to MAMP' page or open another browser window or tab. ![]() You might want to have several Joomla! sites on your local computer for development each with a unique MySQL database that doesn't mix with another. Before you go on it would be good to have the database and a username set up in the MAMP environment. If you don't know it then you can find it out from your configuration file from the live site. I am going to assume that you know your MySQL User Name from your live site. That way when you import your database from the live site it will have the same name. MySQL User Name: - what you want to do here is use the MySQL User Name that is used on your live site. 'Host Name' - in this field type in 'localhost' (without the quotations) Now you are at 'step 1' of the MySQL database configuration and you need to fill in some fields. When you are ready click the 'Next>' at the top right of the page. There is nothing to set here but you may want to read the license if you have never done so. At the top of the page there is the 'Next>' button, click that. If there are things that do need to be fixed you'll have to deal with them before you can continue. That's OK, it won't stop the installation so let's continue. In the recommended settings (middle section) I have one red colored 'OFF' instead of a green 'ON' for 'Display Errors'. Either a 'Yes', or 'Available', or 'Writeable'. Most everything on that page, providing that everything is OK, will be a positive reply to the checks. The URL will change to and you will see the Joomla! Installer pre-installation check web page. In the URL of your web browser, if you haven't closed the 'Welcome to MAMP' window you will see the URL Change that URL or copy it to another browser window or tab to read and hit the return or enter button. ![]() Once it is in there it's time to go to your web browser. That's where you are going to put the 'Joomla_1' folder with all it's sub folders and files. Open the MAMP folder up and look for the 'htdocs' folder. MAMP should be in a folder in your 'Applications' folder. Now go to your 'Applications' folder where your MAMP program is. I'm going to leave it 'Joomla_1' (without the quotation marks) for this lesson. You can rename this folder, but not any of the files inside it, to whatever you want. When the package downloaded to my computer it automatically unzipped to a folder called 'Joomla_1'. Now go and get a full install of Joomla! from If you see this page with the information above on it you are good to go. To connect to the MySQL Server from your own scripts use the following connection parameters: The Web page will have some information that you will want to use with the Joomla! install. Use the one that is convenient for you.On my computer it launched Safari. The first method is using Finder and the TextEdit app, and the second is using the Terminal app. To solve this problem all we need to do is change the phpMyAdmin configuration file to use the actual password of the MySQL root user. Thus, after changing the password of the MySQL root user, I forgot to set up the phpMyAdmin configuration file. Recently I bought a new computer and I decided not to transfer the settings from the old computer, but to set up a new computer from scratch. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. PhpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. Mysqli_real_connect(): (HY000/1045): Access denied for user (using password: YES) To find out the exact cause of the problem, you need to look in the phpMyAdmin error message. The reasons for this problem with access to the phpMyAdmin web page can be different in different cases. If you use the non-standard version of the app, but the PRO one, then in the following steps, replace “MAMP” with “MAMP PRO”, respectively. I’m using version 5.1 of the MAMP app, but in your case there can be any other version of the MAMP app. When I try to access the phpMyAdmin web page located at localhost/phpMyAdmin/index.php, the following error message appears: On my macOS devices I use MAMP app by appsolute GmbH for local web development.
0 Comments
Leave a Reply. |