Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › WAMP/LAMP/MAMP mySQL username & password (localhost Servers)
New Posts  All Forums:Forum Nav:

WAMP/LAMP/MAMP mySQL username & password (localhost Servers)

post #1 of 6
Thread Starter 
Hey everyone,
Does anybody work with WAMP, LAMP or MAMP on their computers for building database driven websites locally? I have purchased a VPS with HostGator but I would also like to be able to build locally as it saves time in development.

The issue I am faced with is that as soon as I import my .sql database file, it says "#1044 - Access denied for user 'root@localhost' to database 'information_schema'"

And it says this for all 3 servers that I am running locally too: WAMP, LAMP and MAMP.

I have managed to actually connect to the database from LAMP but that was because it let me choose the MySQL username and password during the install process. And it's still not quite working properly due to the information_schema not hooking up. The other 2 generated them automatically during the server installs and I'm not sure where to find them?

Not sure if anybody else has encountered this issue before with MySQL database connectivity but I figured I would ask. tongue.gif

Here is a picture of the mySQL import error in WAMP:
capturedm.png

Any help is greatly appreciated.
Thanks!
Edited by revlimiter - 2/27/11 at 2:57pm
My System
(15 items)
 
HTPC
(8 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7 2600K Gigabyte Z68X-UD3H-B3 MSI GTX480 Lightning 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOptical DriveOS
10TB 7500RPM SATA3 64GB Crucial M4 CT064M4SSD2 (Boot Drive) Lite-On IHAS124-04 DVD RW Windows 10 Ultimate 64-bit 
MonitorKeyboardPowerCase
Dual Screen (x2) Dell UltraSharp U2412M 24" IPS... Apple Keyboard (A1243) Antec Truepower New 650W Modular Corsair Carbide Series 500R 
MouseMouse PadOther
Logitech MX Anywhere 2 None Cooler Master Hyper 212+ 
CPUMotherboardGraphicsRAM
AMD A6-5400K MSI FM2-A75MA-E35 AMD Radeon HD 7540D 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOSCase
64GB Crucial M4 CT064M4SSD2 Toshiba HDKPC08 3TB SATA3 7200RPM 32MB Cache Windows 8 Professional 64-bit Apex DM-387 mATX HTPC Case w/ 275W PSU 
  hide details  
Reply
My System
(15 items)
 
HTPC
(8 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7 2600K Gigabyte Z68X-UD3H-B3 MSI GTX480 Lightning 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOptical DriveOS
10TB 7500RPM SATA3 64GB Crucial M4 CT064M4SSD2 (Boot Drive) Lite-On IHAS124-04 DVD RW Windows 10 Ultimate 64-bit 
MonitorKeyboardPowerCase
Dual Screen (x2) Dell UltraSharp U2412M 24" IPS... Apple Keyboard (A1243) Antec Truepower New 650W Modular Corsair Carbide Series 500R 
MouseMouse PadOther
Logitech MX Anywhere 2 None Cooler Master Hyper 212+ 
CPUMotherboardGraphicsRAM
AMD A6-5400K MSI FM2-A75MA-E35 AMD Radeon HD 7540D 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOSCase
64GB Crucial M4 CT064M4SSD2 Toshiba HDKPC08 3TB SATA3 7200RPM 32MB Cache Windows 8 Professional 64-bit Apex DM-387 mATX HTPC Case w/ 275W PSU 
  hide details  
Reply
post #2 of 6
Why are you trying to mess with one of MySQL's internal tables?
Underground
(14 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 920 C0 ASUS P6T6 WS Revolution GTX 460 TR3X6G1600C8D 
Hard DriveOptical DriveCoolingOS
WD1001FALS SAMSUNG SH-S223F 22X DVD MULTI Corsair H50 Fedora 16 KDE x86_64 
MonitorKeyboardPowerCase
HP w19b Microsoft Comfort Curve Corsair CX600 Thermaltake Armor VA8003BWS 
MouseMouse Pad
Razer DeathAdder Black 
  hide details  
Reply
Underground
(14 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 920 C0 ASUS P6T6 WS Revolution GTX 460 TR3X6G1600C8D 
Hard DriveOptical DriveCoolingOS
WD1001FALS SAMSUNG SH-S223F 22X DVD MULTI Corsair H50 Fedora 16 KDE x86_64 
MonitorKeyboardPowerCase
HP w19b Microsoft Comfort Curve Corsair CX600 Thermaltake Armor VA8003BWS 
MouseMouse Pad
Razer DeathAdder Black 
  hide details  
Reply
post #3 of 6
Thread Starter 
I am not trying to, however that is the error message that I receive when I try to import my .SQL file from phpmyadmin.

Sorry, I am pretty new to this.. Does that error message state what the problem is or will I need to post more info to be sure on that?

Thanks,
My System
(15 items)
 
HTPC
(8 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7 2600K Gigabyte Z68X-UD3H-B3 MSI GTX480 Lightning 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOptical DriveOS
10TB 7500RPM SATA3 64GB Crucial M4 CT064M4SSD2 (Boot Drive) Lite-On IHAS124-04 DVD RW Windows 10 Ultimate 64-bit 
MonitorKeyboardPowerCase
Dual Screen (x2) Dell UltraSharp U2412M 24" IPS... Apple Keyboard (A1243) Antec Truepower New 650W Modular Corsair Carbide Series 500R 
MouseMouse PadOther
Logitech MX Anywhere 2 None Cooler Master Hyper 212+ 
CPUMotherboardGraphicsRAM
AMD A6-5400K MSI FM2-A75MA-E35 AMD Radeon HD 7540D 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOSCase
64GB Crucial M4 CT064M4SSD2 Toshiba HDKPC08 3TB SATA3 7200RPM 32MB Cache Windows 8 Professional 64-bit Apex DM-387 mATX HTPC Case w/ 275W PSU 
  hide details  
Reply
My System
(15 items)
 
HTPC
(8 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7 2600K Gigabyte Z68X-UD3H-B3 MSI GTX480 Lightning 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOptical DriveOS
10TB 7500RPM SATA3 64GB Crucial M4 CT064M4SSD2 (Boot Drive) Lite-On IHAS124-04 DVD RW Windows 10 Ultimate 64-bit 
MonitorKeyboardPowerCase
Dual Screen (x2) Dell UltraSharp U2412M 24" IPS... Apple Keyboard (A1243) Antec Truepower New 650W Modular Corsair Carbide Series 500R 
MouseMouse PadOther
Logitech MX Anywhere 2 None Cooler Master Hyper 212+ 
CPUMotherboardGraphicsRAM
AMD A6-5400K MSI FM2-A75MA-E35 AMD Radeon HD 7540D 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOSCase
64GB Crucial M4 CT064M4SSD2 Toshiba HDKPC08 3TB SATA3 7200RPM 32MB Cache Windows 8 Professional 64-bit Apex DM-387 mATX HTPC Case w/ 275W PSU 
  hide details  
Reply
post #4 of 6
Where did you get this .sql file that you're trying to import? Or, maybe, HOW did you get it?
Underground
(14 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 920 C0 ASUS P6T6 WS Revolution GTX 460 TR3X6G1600C8D 
Hard DriveOptical DriveCoolingOS
WD1001FALS SAMSUNG SH-S223F 22X DVD MULTI Corsair H50 Fedora 16 KDE x86_64 
MonitorKeyboardPowerCase
HP w19b Microsoft Comfort Curve Corsair CX600 Thermaltake Armor VA8003BWS 
MouseMouse Pad
Razer DeathAdder Black 
  hide details  
Reply
Underground
(14 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 920 C0 ASUS P6T6 WS Revolution GTX 460 TR3X6G1600C8D 
Hard DriveOptical DriveCoolingOS
WD1001FALS SAMSUNG SH-S223F 22X DVD MULTI Corsair H50 Fedora 16 KDE x86_64 
MonitorKeyboardPowerCase
HP w19b Microsoft Comfort Curve Corsair CX600 Thermaltake Armor VA8003BWS 
MouseMouse Pad
Razer DeathAdder Black 
  hide details  
Reply
post #5 of 6
Thread Starter 
I exported it from the live site by logging in to phpmyadmin on the VPS, hitting the Export tab at the top right, selecting all of the tables and hitting go. I don't think I messed with anything during the export it was all kept as default.

Should I not have exported information schema? I can't remember if it let me select that table. What exactly is stored in information schema?

Thanks!
My System
(15 items)
 
HTPC
(8 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7 2600K Gigabyte Z68X-UD3H-B3 MSI GTX480 Lightning 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOptical DriveOS
10TB 7500RPM SATA3 64GB Crucial M4 CT064M4SSD2 (Boot Drive) Lite-On IHAS124-04 DVD RW Windows 10 Ultimate 64-bit 
MonitorKeyboardPowerCase
Dual Screen (x2) Dell UltraSharp U2412M 24" IPS... Apple Keyboard (A1243) Antec Truepower New 650W Modular Corsair Carbide Series 500R 
MouseMouse PadOther
Logitech MX Anywhere 2 None Cooler Master Hyper 212+ 
CPUMotherboardGraphicsRAM
AMD A6-5400K MSI FM2-A75MA-E35 AMD Radeon HD 7540D 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOSCase
64GB Crucial M4 CT064M4SSD2 Toshiba HDKPC08 3TB SATA3 7200RPM 32MB Cache Windows 8 Professional 64-bit Apex DM-387 mATX HTPC Case w/ 275W PSU 
  hide details  
Reply
My System
(15 items)
 
HTPC
(8 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7 2600K Gigabyte Z68X-UD3H-B3 MSI GTX480 Lightning 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOptical DriveOS
10TB 7500RPM SATA3 64GB Crucial M4 CT064M4SSD2 (Boot Drive) Lite-On IHAS124-04 DVD RW Windows 10 Ultimate 64-bit 
MonitorKeyboardPowerCase
Dual Screen (x2) Dell UltraSharp U2412M 24" IPS... Apple Keyboard (A1243) Antec Truepower New 650W Modular Corsair Carbide Series 500R 
MouseMouse PadOther
Logitech MX Anywhere 2 None Cooler Master Hyper 212+ 
CPUMotherboardGraphicsRAM
AMD A6-5400K MSI FM2-A75MA-E35 AMD Radeon HD 7540D 8GB Patriot G2 Series Division DDR3 @ 9-9-9-24 ... 
Hard DriveHard DriveOSCase
64GB Crucial M4 CT064M4SSD2 Toshiba HDKPC08 3TB SATA3 7200RPM 32MB Cache Windows 8 Professional 64-bit Apex DM-387 mATX HTPC Case w/ 275W PSU 
  hide details  
Reply
post #6 of 6
There's no need to export the 'mysql' database, the 'information_schema' database, or any tables contained within them. Those are maintained internally by MySQL and Really Bad Things Will Happen if you mess with them without knowing exactly what you're doing.

Try your export again, but this time skip those two databases.
Underground
(14 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 920 C0 ASUS P6T6 WS Revolution GTX 460 TR3X6G1600C8D 
Hard DriveOptical DriveCoolingOS
WD1001FALS SAMSUNG SH-S223F 22X DVD MULTI Corsair H50 Fedora 16 KDE x86_64 
MonitorKeyboardPowerCase
HP w19b Microsoft Comfort Curve Corsair CX600 Thermaltake Armor VA8003BWS 
MouseMouse Pad
Razer DeathAdder Black 
  hide details  
Reply
Underground
(14 items)
 
  
CPUMotherboardGraphicsRAM
Core i7 920 C0 ASUS P6T6 WS Revolution GTX 460 TR3X6G1600C8D 
Hard DriveOptical DriveCoolingOS
WD1001FALS SAMSUNG SH-S223F 22X DVD MULTI Corsair H50 Fedora 16 KDE x86_64 
MonitorKeyboardPowerCase
HP w19b Microsoft Comfort Curve Corsair CX600 Thermaltake Armor VA8003BWS 
MouseMouse Pad
Razer DeathAdder Black 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › WAMP/LAMP/MAMP mySQL username & password (localhost Servers)