Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Thread Tools Search this Thread Display Modes
Old Jun 5, 2010, 09:16 AM   #1
macrumors newbie
Join Date: Aug 2009
#1045 Cannot log in to the MySQL server (Different than most cases)

Hey, im trying to get phpmyadmin set up and I have successfully setup phpmyadmin before (on different server for different site and on windows) and I have went through the same steps as I have before with only a few differences but this time when I try to log in I get #1045 Cannot log in to the MySQL server, and I have looked through tons of different forums for the past 4 days now trying all sorts of different techniques and nothing will work at all. My mysql login works 100% and the account have full privileges to everything, I have also started to use MySQL Workbench to help give me a bit more of a graphical aid to help pinpoint any problems but as far as i can see the is non, is there maybe somthing wrong with my I also have the apache2 server running and I uploaded phpmyadmin onto the server but I still get the same error message, I then tried to redirect to my website from apache through the but still got the same message,

Im running PHP 5.3.2, phpmyadmin 3.3.3 and MySQL 5.1.47 is there maybe a conflict with these versions going on?

my config file is this


/* Servers configuration */
$i = 0;

/* Server: MySiteForums [1] */
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

/* End of servers configuration */

$cfg['blowfish_secret'] = '4c02d5e1af2b86.89214560';
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
I had my username and password in to start with but was told that u dont need it when using cookies

I have also completely uninstalled and reinstalled MySql a number of times now, I feel like im just missing something very simple lol

Any help would be appreciated.

Last edited by Chriss316; Jun 5, 2010 at 10:00 AM.
Chriss316 is offline   0 Reply With Quote
Old Jun 5, 2010, 01:59 PM   #2
Moderator emeritus
angelwatt's Avatar
Join Date: Aug 2005
Location: USA
Seems to match my file for the most part. I have an auth type of config with user name and password supplied. For extension I have mysql. None of the settings you supplied look wrong. Have you tried the other auth type ad supplied a user name and password just to see if it works?

The only other thing that comes to mind to check on is to see what the file permissions are for the config file and others to see if they are what they need to be. I found this post about an issue with phpmyAdmin and password encryption type. The solution was to use the old_password function.
angelwatt is offline   0 Reply With Quote
Old Jun 5, 2010, 04:07 PM   #3
Thread Starter
macrumors newbie
Join Date: Aug 2009
Ok so I redownloaded the lastest version to get a copy of the sample inc file and used that as the base for inc file I think the problems may of been with the advanced settings

My config now looks like this
/* vim: set expandtab sw=4 ts=4 sts=4: */
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use setup/
 * All directives are explained in Documentation.html and on phpMyAdmin
 * wiki <>.
 * @version $Id$
 * @package phpMyAdmin

 * This is needed for cookie based authentication to encrypt password in
 * cookie
$cfg['blowfish_secret'] = '4c02d5e1af2b86.89214560'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

 * Servers configuration
$i = 0;

 * First server
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

/* User for advanced features */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'MY_PASSWORD';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
/* Contrib / Swekey authentication */
$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

 * End of servers configuration

 * Directories for saving/loading files from server
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

I now have no problems logging in through the sites folder using localhost on the test server but I still cant get logged in through my hosting server on my domain, must be disabled or lower version on the domain, but I'm for switching providers soon to another host who I know has up to date servers and should be able to get up and running properly with
Chriss316 is offline   0 Reply With Quote

MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
#1045 cannot log in to the mysql server - PhpMyAdmin lukaz32 Web Design and Development 4 Dec 5, 2012 02:49 AM
Cannot log in to Apple Discussion Forum JohnnyBgood Apple, Industry and Internet Discussion 3 Apr 23, 2009 09:53 AM
cannot log in to mac mini wedge234 Mac mini 2 May 18, 2008 06:19 PM
cannot log in to network dadio2002 MacBook Pro 0 Aug 24, 2007 08:37 AM

All times are GMT -5. The time now is 10:11 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013,, LLC