Hi, I can not create a database in the phpmyadmin. How do I enable the privilidges so I can create a database? 
<M/> 170 Why so serious? Featured Poster
Recommended Answers
Jump to PostOkay, so you need to check the phpinfo from the xampp control panel to make sure it reflects there.
Jump to PostIn 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.
Jump to PostI 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 …
Jump to PostThanks. Line 100 on the security.php is $conn_id = ftp_connect("127.0.0.1");
if ($command == "ftp") { if (($handle = @fsockopen($host, 21, $errno, $errstr, $timeout)) == true) { @fclose($handle); $conn_id = ftp_connect("127.0.0.1"); $login_result = @ftp_login($conn_id, "newuser", "wampp"); if (!$conn_id || !$login_result) { $status = 0; } else { $status …
Jump to Poston line 23 on your security file which is this:
$timeout = "1";Change it to 0 then restarted your computer.
All 42 Replies
pixelsoul 272 Red Pill Featured Poster
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.
LastMitch
Hi, I can not create a database in the phpmyadmin. How do I enable the privilidges so I can create a database?
Read this:
<M/> 170 Why so serious? Featured Poster
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
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
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
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
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
I never did anything to it. other than increase the max execution time to 60. any clues?
IIM 163 Master Poster
pixelsoul 272 Red Pill Featured Poster
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
It opens a security.php and says there is an error on line 100.j
LastMitch
@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
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
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
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
Well I restarted the server and I saved the changes to the php.ini... not much after that.
pixelsoul 272 Red Pill Featured Poster
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
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
Remove the semicolon.. lol
If the semicolon is there, that is commenting it out.
<M/> 170 Why so serious? Featured Poster
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
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
where do I look? there is a lot of lines of "code" on the page... where do I find it?
IIM 163 Master Poster
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
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
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
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
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
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...
LastMitch
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.
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.