Mamp phpmyadmin access denied8/8/2023 įor those who are interested, I've got the following for automating my deployment.īy all means, it's not perfect nor is it complete but it does the job with a minimal investment of my time. Been very busy with a deadline that inevitably dragged on and on. Now I just have to setup my dual config php files and I think fix the broken page links, as mentioned in some other Sorry for the late response. This way the table import technique worked! Hope this might help others also using this funky cPanel / phpMyAdmin / MySql setup of mine. Change the config.php settings only on the live server.Export from the local then import to the live.add the user, which I log into phpmyadmin with, to that new live database.Rename the local database exactly the same as the newly created database on the live server, then.Move files from the local server folder to the live server.But how my phpmyadmin/mysql is setup won't allow users to access tables they aren't "added" to, so there's no way for the user to add in tables to a non-existent table. I think that the compiling of the tables during export still somehow stores the local name of the database, so during import it tries to create a new database with that name. All the user and databases are prefixed with myname_, and I have to manually add users to databases through the wizard.Īh, thanks for the tip arjen! In the end this technique worked smoothly!Īt first it this technique of exporting and importing the tables didn't work either, and gave me the exact same error. Other than the config.php file, what else can I do to remedy this error? Another catch with my setup is that with my host's cPanel/ phpmyadmin setup, I have to create mysql users and databases through a wizard. I ended up copy and pasting the lines of code for credentials from another config file ) It just said "Installer config data appears below", then nothing. (When I first opened the file, I couldn't find the db credentials at the bottom.if I edit this file, what should I put as the database name, etc., since the db hasn't even been created yet?.does editing this file have anything to do with this error?.I've tried editing the credential settings in the config.php file in the site/ folder, but a few things are confusing me: MySQL said: #1044 - Access denied for user to database 'sitename_pw' CREATE DATABASE IF NOT EXISTS `sitename_pw` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |