Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
I am now trying to set up a web server (for funny), I have already installed apache, active perl, php & mysql (all windows nt version) and all work

now, after i installed the phpmyadmin, i loaded the index.php file and got the following error:

-----------------------------------------------

Welcome to phpMyAdmin 2.5.4

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Error

MySQL said:

#1130 - Host 'kenkk' is not allowed to connect to this MySQL server
-----------------------------------------------

I double check the host, username(use "root") and password(root password) and all correct

Can I know how to solve??

Sponsored Links
Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
The user ID kenkk does not have the proper rights. Most of the time the server called is localhost and the ID should be root.

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
Quote
quote:
Originally posted by 1QuickSI:
The user ID kenkk does not have the proper rights. Most of the time the server called is localhost and the ID should be root.
So, how can I fix it??
I am newbie, can you tell me step by step
Thanks!!

Joined: Jan 2000
Posts: 5,073
Admin Emeritus
Admin Emeritus
Joined: Jan 2000
Posts: 5,073
If this is a local machine, you should be using root to get to MySQL...


UBB.classic: Love it or hate it, it was mine.
Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
Yes, I already use the "root" to get to Mysql but still failed with the error code 1130

Sponsored Links
Joined: Jan 2000
Posts: 5,073
Admin Emeritus
Admin Emeritus
Joined: Jan 2000
Posts: 5,073
Are you trying to connect to "localhost"/"127.0.0.1", or to your machine's hostname?


UBB.classic: Love it or hate it, it was mine.
Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
i tried "localhost" and my ip address but both failed with error 1130

Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
Can you login to mysql at the command line?

./mysql

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
Quote
quote:
Originally posted by 1QuickSI:
Can you login to mysql at the command line?

./mysql
yes, I can login by using root

Joined: Jul 2003
Posts: 273
Member
Member
Offline
Joined: Jul 2003
Posts: 273
what about root-beer? Ok that wasn't helpful. Sorry.

Sponsored Links
Joined: Jul 2003
Posts: 273
Member
Member
Offline
Joined: Jul 2003
Posts: 273
btw I'm following this with interest as I plan to make my machine a web server too for testing stuff. All the same stuff as yours.

Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
Ok so you can login to MySQL as root. Lets now confirm you have permission to create a database via the command line.

mysql> create database SomedbName;

It should return:
Query OK, 1 row affected (0.23 sec)

Now lets select and change to this database.

mysql> use SomedbName;

Now lets make sure you can view the database.

mysql> show tables;

There should be no tables to view and MySQL will tell you this. As long as these work then MySQL should be fine.

Instaed of removing the database (mysql> drop SomedbName;) lets leave it so we have something to look at in phpMyAdmin

Next we will need to take a look at config.inc.php Have you modified this file once you untar'd the files and placed them in your web root?

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
Thanks for your prompt response!!

I got this error when I typed: create database SomedbName in command line
[Linked Image]

same result with: create database SomedbName;

Joined: May 2000
Posts: 1,356
Addict
Addict
Joined: May 2000
Posts: 1,356
Try to run E:mysqlbin>mysql

And enter the commands when you drop to the mysql prompt. Like

mysql> create ...

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
Thanks!!

Now I got this error:
[Linked Image]

Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
Ack, a windos box eek

My background is MySQL under Linux (RedHat) Hmmm... I guess the commands will be the same I will just need to figure out how the command lines differ in the executable.

What version of Windows server is this btw?

Have you run winmysqladmin? The first time you are asked to create one user that is admin/root.

Lets go back and check permissions...

restart MySql server with --skip-grant-tables
Login to mysql --user=root
select * from mysql.user
check that 'admin' is there with a correct password set AND FOR Host='localhost'
if yes, then you mistyped your 'admin' password. Change it.

if not, then change the 'admin' entry:

update mysql.user set Host='localhost',Password=PASSWORD('youradminpassword') WHERE User='admin';
flush privileges;
exit;

Now try restarting MySql server normally. Let us know how this goes...

Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
I have another idea cool

Try editing your hosts file with

127..0.1 localhost

You can also try to specify the IP address of the server as the host:

mysql -h your.ip.address.here

Also take a look at:
http://www.mysql.com/doc/en/Default_privileges.html

Hope something here helps smile

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
1QuickSI

I missed your message as the post is turned to Pg.2
I am using Windows XP
I will try try and give result to you tomorrow

Thanks

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
Quote
quote:
Originally posted by 1QuickSI:
restart MySql server with --skip-grant-tables
Login to mysql --user=root
select * from mysql.user
check that 'admin' is there with a correct password set AND FOR Host='localhost'
if yes, then you mistyped your 'admin' password. Change it."

- Can I know where should I key the above commands, in command line?
mysql> --user=root
or
e:mysqlbin> --user=root
or
e:mysqlbin> mysqld-nt --user=root
-------------------------------------------------
quote:
[qb]Originally posted by 1QuickSI:
update mysql.user set Host='localhost',Password=PASSWORD('youradminpassword') WHERE User='admin';
flush privileges;
exit;
[/qb]
I input the commands and the error 1044: Access denied for user: '@localhost' to database 'mysql'
-------------------------------------------------
Quote
quote:
Originally posted by 1QuickSI:
Try editing your hosts file with

127..0.1 localhost

- which file should I edit?
-------------------------------------------------
quote:
[qb]Originally posted by 1QuickSI:
mysql -h your.ip.address.here[/qb]
- after enter the command---1130 - Host 'kenkk' is not allowed to connect to this MySQL server


I follow the following link to install MySql only
http://www.mattjacob.org/server/page4.html

Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
When I make mention of typing a command line it should be assumed that it is within the MySQL program at the prompt MySQL> As you need to be within it to execute the commands.

Now when you try to conenct to MySQL are you on the same box as the install or from your workstation?

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
1QuickSI

Thanks for your reply.

Quote
quote:
Originally posted by kenhk:
[QUOTE]Originally posted by 1QuickSI:
[qb]restart MySql server with --skip-grant-tables
Login to mysql --user=root
select * from mysql.user
check that 'admin' is there with a correct password set AND FOR Host='localhost'
if yes, then you mistyped your 'admin' password. Change it."

[Linked Image]
-------------------------------------------------
quote:
[qb]Originally posted by 1QuickSI:
update mysql.user set Host='localhost',Password=PASSWORD('youradminpassword') WHERE User='admin';
flush privileges;
exit;
[/qb]
I input the commands and the error 1044: Access denied for user: '@localhost' to database 'mysql'
-------------------------------------------------
Quote
quote:
Originally posted by 1QuickSI:
Try editing your hosts file with

127..0.1 localhost

- which file should I edit?
-------------------------------------------------
quote:
[qb]Originally posted by 1QuickSI:
mysql -h your.ip.address.here[/qb]
- after enter the command---1130 - Host 'kenkk' is not allowed to connect to this MySQL server

I tried on the same box as the install and from my workstation

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
anyone can help?

Joined: Feb 2002
Posts: 40
Member
Member
Offline
Joined: Feb 2002
Posts: 40
I am still unable to fix this problem. Hope anyone can help me!

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
xp - there's your problem, I do not know of anyone who's successfully gotten a website running on it - it's a desktop OS and MS wrote permissions to be exactly that. You might search for some info on the phpmyadmin site for an xp install... good luck smile


- Allen wavey
- What Drives You?

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)