Solved Cant create database table in phpmyadmin

[Prox Plox]

Hello!
​

When im importing the "mysql.sql" file it just says:

(see picture)
http://s1316.photobucket.com/user/Pontus_Claesson/media/Skaumlrmklipp_zpsjajgd4zl.png.html

I have no idea what the problem is here.
Can someone help me? :/

 

[Jack Parsons]

I suggest you to use HeidiSQL, it's free and better than phpmyadmin. The error message is clear enough, "No database selected". In order to create / drop / alter tables, you need to select a database (If you were on the raw console, you'd need to type "USE database_name;". It does not matter if you're logged in, you can't create / drop / alter tables without using / selecting a database). On HeidiSQL, all you have to do is select the database (Just click on it), then carry on with your drop command or any imports.

 

[Tarek]

Hello!
​

When im importing the "mysql.sql" file it just says:

(see picture)
http://s1316.photobucket.com/user/Pontus_Claesson/media/Skaumlrmklipp_zpsjajgd4zl.png.html

I have no idea what the problem is here.
Can someone help me? :/

Först på den vänstra spalten. Så finns din databas som du har skapat antar jag. Det är bara att du klickar på den sen "import". Då ska det funka precis utmärkt.

english:
First on the left side. There you can find your database that you have created I hope. Just click on your database then "import". Then it should just work fine.

 

[slavi]

Just create a new database.

CREATE DATABASE dbname;

Or if you have already created it, just select it via the left-side-menu.

or

 USE dbname

 

[Prox Plox]

Thanks for the replies!

Alright, the problem here is that I cant acces my new database for some reason. Ive tried to make a new one, but its the same issue. When I click on a database in the left side it just says loadning...

("Loading")
http://s1316.photobucket.com/user/Pontus_Claesson/media/asd_zpsgbip0cal.png.html

...and nothing happens. Ive allso noticed that I cant acces any of my databases. Strange.

(What happens when I try to open an old already existing database)
http://s1316.photobucket.com/user/Pontus_Claesson/media/hgjk_zpsjlyqb31d.png.html

Uuuh, Im gonna try HeaidiSql instead.
How do I "replace" it with HeidiSql is my question then.
(Im kinda new to this)

 

[Jack Parsons]

(What happens when I try to open an old already existing database)
http://s1316.photobucket.com/user/Pontus_Claesson/media/hgjk_zpsjlyqb31d.png.html

Right there... "command denied to user ''@'localhost'". You're trying to access the databases with a ghost user ('' (Which is actually fine in MySQL)), nevertheless, this nameless user doesn't have the proper privileges in order to access anything. You're not going to make it even with HeidiSQL this way (Probably your phpmyadmin was not configured properly). Do you know the root password? If you don't, you'll have to reset the root password with a cryptic workaround.

 

[slavi]

What are you using?

Windows or linux ?
Xampp or Uniserver ?

If you are using Xampp please use Uniserver since xampp is just for test purposes!

 

[Prox Plox]

Right there... "command denied to user ''@'localhost'". You're trying to access the databases with a ghost user ('' (Which is actually fine in MySQL)), nevertheless, this nameless user doesn't have the proper privileges in order to access anything. You're not going to make it even with HeidiSQL this way (Probably your phpmyadmin was not configured properly). Do you know the root password? If you don't, you'll have to reset the root password with a cryptic workaround.

Yeah, I know the root password.

What are you using?

Windows or linux ?
Xampp or Uniserver ?

If you are using Xampp please use Uniserver since xampp is just for test purposes!

Im using Windows with Xampp, well I guess I'll switch to Uniserver then.

 

[Jack Parsons]

It's a matter of preference (Xampp vs Uniserver), if you're just testing the server. You could also install Apache and MySQL separately and manually, and access the databases via console or an external software like HeidiSQL. If you know the root password, be sure you're logged in with it (Somehow, on that case, you were not).

 

[slavi]

I agree with jack, but just for newbies it's very recommended to use uniserver!

 

[Prox Plox]

I actually installed UniServer and everything is working fine with that program. Like you guys said, It's more simple.