Can't Create Database in Phpmyadmin

Question

<M/> 170 Why so serious?

11 Years Ago

Hi, I can not create a database in the phpmyadmin. How do I enable the privilidges so I can create a database? a1f9ac111e8c5f99ec073858a8c29eef

6 Contributors
42 Replies
704 Views
1 Week Discussion Span
Latest Post 10 Years Ago Latest Post by <M/>

All 42 Replies

LastMitch

11 Years Ago

Hi, I can not create a database in the phpmyadmin. How do I enable the privilidges so I can create a database?

Read this:

http://www.apachefriends.org/f/viewtopic.php?p=138372

Edited 11 Years Ago by LastMitch because: grammer

LastMitch

10 Years Ago

I am using Internet Explorer on windows 8. I am sure I installed this properly, I followed a video on youtube on how to install xampp on windows...

@micheal I think I post this from my preivous post did you do this:

Open the XAMPP Control Panel.

Now you see Apache then click on Admin.

It will bring you to this page: XAMMP for Windows

Then you see on your left nav-bar Status and Security.

Click on the both of them.

Then tell us do you have any read green or red mark or just a post the image of Status page and Security page.

So we can see what requirement on those pages.

Edited 10 Years Ago by LastMitch because: grammer

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

pixelsoul 272 Red Pill Featured Poster · Answer 1 · 2013-04-17T02:28:42+00:00

Are you logged in as "root"? If you are, you might need to check the settings for that user to make sure the rights are set correctly so that they can create a database.

<M/> 170 Why so serious? Featured Poster · Answer 2 · 2013-04-17T02:39:23+00:00

Are you logged in as "root"? If you are, you might need to check the settings for that user to make sure the rights are set correctly so that they can create a database.

I am sure I am logged in as the root. How do I check if I am?

pixelsoul 272 Red Pill Featured Poster · Answer 3 · 2013-04-17T02:46:03+00:00

Close the browser and then open it back up. Go to http://localhost/phpmyadmin , does it ask you to login?

<M/> 170 Why so serious? Featured Poster · Answer 4 · 2013-04-17T02:49:01+00:00

Okay so I have to create a new password but for some odd reason I am seeing an error (again) on the security page (xampp). It said something was wrong with the htdocs on line 100. What do I do? My max execution time has been increased to 60 seconds (originally 30) and in the htdocs (on line 100) i see that it is the ftp connect.

Anyone know what I have to do... i am a bit lost.

<M/> 170 Why so serious? Featured Poster · Answer 5 · 2013-04-17T02:49:45+00:00

Close the browser and then open it back up. Go to http://localhost/phpmyadmin , does it ask you to login?

No.

pixelsoul 272 Red Pill Featured Poster · Answer 6 · 2013-04-17T02:56:43+00:00

I'm lost too, I have xampp installed with none of those problems. Did you by chance change something and bork the install some how? Maybe it would be better to remove it all completely and do a fresh install?

<M/> 170 Why so serious? Featured Poster · Answer 7 · 2013-04-17T03:08:32+00:00

I never did anything to it. other than increase the max execution time to 60. any clues?

IIM 163 Master Poster · Answer 8 · 2013-04-17T03:19:22+00:00

IIM 163 Master Poster

11 Years Ago

check this http://drupal.org/node/130231

pixelsoul 272 Red Pill Featured Poster · Answer 9 · 2013-04-17T03:26:23+00:00

One of the things I am confused about is the htdocs error, that is a directory. What file are you checking a line number in?

<M/> 170 Why so serious? Featured Poster · Answer 10 · 2013-04-17T03:56:20+00:00

It opens a security.php and says there is an error on line 100.j

LastMitch · Answer 11 · 2013-04-17T03:59:25+00:00

@micheal

Do this:

Open the XAMPP Control Panel.

Now you see Apache then click on Admin.

It will bring you to this page: XAMMP for Windows

Then you see on your left nav-bar Status and Security.

Click on the both of them.

Then tell us do you have any read green or red mark or just a post the image of Status page and Security page.

So we can see what requirement on those page that you need to do.

pixelsoul 272 Red Pill Featured Poster · Answer 12 · 2013-04-17T04:00:31+00:00

You must mean this page https://localhost/security/index.php

You're going to need to provide the exact error message that you're seeing.

I would strong consider removing and re-installing. You're having a lot of problems for just installing and not changing anything, and it sounds like to me the install is corrupted in some way.

<M/> 170 Why so serious? Featured Poster · Answer 13 · 2013-04-17T04:09:24+00:00

Okay... the exact error message is this:
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\security\htdocs\security.php on line 100

Any clues? I don't plan on un-installing (I actually don't know how to even do that).

pixelsoul 272 Red Pill Featured Poster · Answer 14 · 2013-04-17T04:28:00+00:00

After you made that change to your php.ini file, did you stop and start the server again?

You can check the phpinfo from the xampp control panel, to see if it reflects in there the correct value that you set it to.

<M/> 170 Why so serious? Featured Poster · Answer 15 · 2013-04-17T04:41:40+00:00

Well I restarted the server and I saved the changes to the php.ini... not much after that.

pixelsoul 272 Red Pill Featured Poster · Answer 16 · 2013-04-17T04:51:50+00:00

So, does the value in the phpinfo for max_execution_time show the correct value? And you should make the change and save it THEN restart the server ;-)

I need to go to bed here in a minute, just an FYI in case I don't respond right away.

<M/> 170 Why so serious? Featured Poster · Answer 17 · 2013-04-17T04:53:48+00:00

This is what I put:
;max_execution_time = 60

Am I suppose to have that semicolon in the beginning?

pixelsoul 272 Red Pill Featured Poster · Answer 18 · 2013-04-17T04:58:05+00:00

Remove the semicolon.. lol

If the semicolon is there, that is commenting it out.

<M/> 170 Why so serious? Featured Poster · Answer 19 · 2013-04-17T04:59:35+00:00

actually it was never there... I just added here incase you thought I was weird about semicolons.

But I don't see anything wrong with "the code".

pixelsoul 272 Red Pill Featured Poster · Answer 20 · 2013-04-17T05:01:38+00:00

Okay, so you need to check the phpinfo from the xampp control panel to make sure it reflects there.

<M/> 170 Why so serious? Featured Poster · Answer 21 · 2013-04-17T05:08:19+00:00

where do I look? there is a lot of lines of "code" on the page... where do I find it?

IIM 163 Master Poster · Answer 22 · 2013-04-17T15:52:13+00:00

As pixelsoul suggested anything after comma is ignored .Check out http://php.net/manual/en/configuration.file.php

; any text on a line after an unquoted semicolon (;) is ignored
[php] ; section markers (text within square brackets) are also ignored

Make a simple program and print phpinfo() data.

<?php
echo phpinfo();
?>

Check if it is showing the change that you did in ini file

semontuffel 0 Newbie Poster · Answer 23 · 2013-04-18T11:14:47+00:00

In MySQL creating a data source does not instantly make a user to go with it. You must clearly make the user and allow acess. I do not more about it, becuase I used phpmyadmin for just 1 month.

<M/> 170 Why so serious? Featured Poster · Answer 24 · 2013-04-21T22:10:14+00:00

Sorry for responding so late, I didn't realize that there were unread comments here.

But anyways, I noticed something strange.

When I went to the database page in phpmyadmin, the "no privilige" message dissapeared. But when I refresh the page, the message is back.

Any idea why I can't get this thing working. I know I am logged in as the root and I am able to work with the .ini file. Any clues?

<M/> 170 Why so serious? Featured Poster · Answer 25 · 2013-04-22T02:08:08+00:00

I increased the max execution time to 120, I still see the same error as before in the xampp/security.... I just don't know what to do.

LastMitch · Answer 26 · 2013-04-22T02:17:21+00:00

I increased the max execution time to 120, I still see the same error as before in the xampp/security.... I just don't know what to do.

micheal, I'm a bit concern of how you are installing this. I mean you can't change php.ini file or other file like this.

You want your local host (XXAMP) have the same setting as Host Server (Internet).

What browser are you using?

Are you using Chrome? Try Firefox.

<M/> 170 Why so serious? Featured Poster · Answer 27 · 2013-04-22T02:58:22+00:00

I am using Internet Explorer on windows 8. I am sure I installed this properly, I followed a video on youtube on how to install xampp on windows...

Can't Create Database in Phpmyadmin

Recommended Answers Collapse Answers

All 42 Replies

Recommended Answers