LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 02-02-2005, 07:13 AM   #1
jackster
LQ Newbie
 
Registered: Jan 2005
Location: Pretoria, South-Africa
Distribution: Mandrake 10
Posts: 19

Rep: Reputation: 0
phpMyAdmin - Access denied!!


I'm using phpMyadmin and can't seem to log into the mysql server. I'm using the http authentication method. I've setup a control user - as per the documentation.txt that comes with it. I've created a 'root' user with 'password' and i can connect to mysql with the password but still i can't connect to mysql via phpmyadmin!!! Any hints/help please?

Thanx

Jack
 
Old 02-02-2005, 09:14 AM   #2
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,477

Rep: Reputation: 87
You mean you can go

#mysql -u root -p
Password:

and when you type the password you can get into the text MySQL interface?
 
Old 02-02-2005, 09:21 AM   #3
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,477

Rep: Reputation: 87
Oh yeah,

When you set up MYSQL, did you do something like this:

1. Install according to BINARY_INSTALL.TXT
2. Do chown -R mysql.mysql /var/lib/mysql
3. Go to /var/run
4. mkdir mysqld
5. chown -R mysql.mysql mysqld
6. Start the server - mysqld_safe --user=mysql & in the /usr/local/mysql/bin/
directory
7. Type in mysql -u root mysql
8. At mysql> prompt type
set password for root@localhost=password('yourpass');

Example:

[root@StefanLinux rylan]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set password for root@localhost=password('yourpass');

This works for me... I am assuming that is what you did BEFORE trying to setup PHPMyAdmin?
 
Old 02-02-2005, 09:21 AM   #4
jackster
LQ Newbie
 
Registered: Jan 2005
Location: Pretoria, South-Africa
Distribution: Mandrake 10
Posts: 19

Original Poster
Rep: Reputation: 0
Yes, and i've done the whole OLD-PASSWORD('mypassword') thing aswell just in-case and done it without it and tried everything. I've also added another user 'mysql' with a password and still no luck

??
 
Old 02-02-2005, 09:58 AM   #5
jackster
LQ Newbie
 
Registered: Jan 2005
Location: Pretoria, South-Africa
Distribution: Mandrake 10
Posts: 19

Original Poster
Rep: Reputation: 0
Not to worry, got it fixed! The answer was laying in config.inc.php
$cfg['Servers'][$i]['connect_type'] = 'socket'; and not tcp.

Thanx anyway.

Ek laik dit kwaai soos gesnyde kaas
 
Old 02-02-2005, 05:04 PM   #6
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,477

Rep: Reputation: 87
Red face

Hiert! Hier is Afrikaners hier! HARDLOOP!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access denied?? Jaster Linux - Software 9 07-25-2004 08:42 PM
getting access denied , when trying to access camera as normal user bennythepitbull Linux - Hardware 2 11-04-2003 03:30 AM
Access Denied to phpMyAdmin 2.5.2-pl1 TastyWheat Linux - Software 0 09-01-2003 11:38 PM
phpmyadmin/access denied xlord Linux - General 3 06-10-2003 06:50 PM
MySQL remote access from Dynamic IP Address via phpMyAdmin Swene Linux - Networking 1 05-21-2002 07:02 PM


All times are GMT -5. The time now is 06:04 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration