Trying to run mysql script through phpMyAdmin

Question

VernonDozier 2,218 Posting Expert

16 Years Ago

I have a Yahoo website that uses phpMyAdmin. I've been given the directive "Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!" I do not know how to run this script (or any script) through phpMyAdmin. I've been looking online and one bit of advice was to click the SQL query window icon and type the following:

mysql mysql -u username -p password < mysql_fix_privilege_tables.sql

where username is my user name and password is my password. mysql is listed twice intentionally here because both the command and the name of the database is mysql, or at least that's what the online advice said. I get the "You have an error in your SQL syntax..." error. Does anyone know how to do this and what I did wrong?

Thanks.

mysql php

9 Contributors
14 Replies
3K Views
6 Years Discussion Span
Latest Post 9 Years Ago Latest Post by Nishant_3

peter_budo 2,532 Code tags enforcer

16 Years Ago

I think your command is in wrong order. Following works for me

mysql -u username  DB_NAME < mysql_fix_privilege_tables.sql -p

Once I execute command I'm asked for password which I type in and job is done.

peter_budo 2,532 Code tags enforcer

16 Years Ago

Yeah you right, only console. Stupid of me...
If you able to log in yahoos' phpMyAdmin there is somewhere option to import or create table out of existing sql file. I gone check on my hosting, give me few minutes...

peter_budo 2,532 Code tags enforcer

16 Years Ago

Yes there is import option for text file that you can use for SQL file import. Please see attached image. Sometimes it may kick off with error message about different type of DB used but that can be solved by editing sql file.

VernonDozier commented: Helpful +5

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.

VernonDozier 2,218 Posting Expert Featured Poster · Answer 1 · 2008-08-07T16:46:50+00:00

I think your command is in wrong order. Following works for me
mysql -u username  DB_NAME < mysql_fix_privilege_tables.sql -p
Once I execute command I'm asked for password which I type in and job is done.

Did you do this through phpMyAdmin or at a command line? I can do it at a command line on my home machine, but I can't get a command line on the web server at Yahoo. I'm stuck going through phpMyAdmin on Yahoo. At the command line on my home machine, it treats that first "mysql" as "find mysql.exe and execute it". Once you are in phpMyAdmin, I don't think it has the same meaning and I think you are no longer supposed to specify the program name (mysql), just like when you type "mysql" at the command line, once you get the "mysql" prompt, you don't type "mysql" anymore. If you were able to do it through phpMyAdmin, can you tell me where you typed that line please?

VernonDozier 2,218 Posting Expert Featured Poster · Answer 2 · 2008-08-07T22:23:37+00:00

Yes there is import option for text file that you can use for SQL file import. Please see attached image. Sometimes it may kick off with error message about different type of DB used but that can be solved by editing sql file.

That worked. Thank you!

jim272 0 Newbie Poster · Answer 3 · 2008-12-08T17:28:13+00:00

May i know what file to import through the phpMyAdmin?

CableGuy2 0 Newbie Poster · Answer 4 · 2008-12-09T09:46:44+00:00

Can someone answer this one? I'm kind of in a jam. Do you copy the code snippet from above into a file named "mysql_fix_privilege_tables.sql" Any help would be great.

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster · Answer 5 · 2008-12-09T18:12:50+00:00

Can someone answer this one? I'm kind of in a jam. Do you copy the code snippet from above into a file named "mysql_fix_privilege_tables.sql" Any help would be great.

Can you please explain what your trying to do?

CableGuy2 0 Newbie Poster · Answer 6 · 2008-12-10T15:31:22+00:00

Can you please explain what your trying to do?

I've recently upgrading my phpAdmin on Yahoo Web Hosting and am getting a message on the bottom that says my PHP MySQL of 3.5 does not match my MySQL 4.1.14 which may cause unpredictable behavior.

With that said when I click on the privledges tab it says I need to run this mysql fix privledges table.sql to fix my tables.

I am a noob at mysql and am not sure how to run scripts I don't have access too. Sounds like the person above me had a similar situation.

Any ideas?

bhall7 0 Newbie Poster · Answer 7 · 2009-02-20T04:55:54+00:00

I'm having the same issue with my Yahoo hosting. When I click privileges in phpMyAdmin, I get the following error:

Warning: Your privilege table structure seems to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!

I have no idea how to run the so-called mysql_fix_privilege_tables script. Any help would be greatly appreciated.

Thanks!

charvie 0 Newbie Poster · Answer 8 · 2011-01-22T06:39:09+00:00

i'm having the same issues T^T

can somebody tell me how to run mysql_fix_privilege_tables? where can i find the script?

smantscheff 265 Veteran Poster · Answer 9 · 2011-01-22T16:07:38+00:00

In my windows system it's in e:\Program Files\MySQL\MySQL Server 5.1\share\mysql_fix_privilege_tables.sql and on my linux system in /usr/bin/mysql_fix_privilege_tables

bbman 12 Junior Poster · Answer 10 · 2011-10-09T01:06:59+00:00

Has anyone on Yahoo tried running the "Repair database" command in the Webhosting Control Panel > Create & Update > MySQL Database area?

Nishant_3 0 Newbie Poster · Answer 11 · 2015-01-31T13:34:03+00:00

There is a tools which is capable of doing all phpmyadmin job packed in single tiny php file.
http://www.techinfobit.com/how-to-import-export-database-without-any-extra-installation/