Over 1 million tech questions and answers.

mysql not downloading

Q: mysql not downloading

MySQL Service detected with wrong path
19:31:53 [mysql] Change XAMPP MySQL and Control Panel settings or
19:31:53 [mysql] Uninstall/disable the other service manually first
19:31:53 [mysql] Found Path: "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL
19:31:53 [mysql] Expected Path: c:\webxamp\mysql\bin\mysqld.exe --defaults-file=c:\webxamp\mysql\bin\my.ini mysql
wht can be the problem?

Read other answers
Preferred Solution: mysql not downloading

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)


I'm a newbie to PHP and MySql.
My problem is this. I host my site on a server that has poor customer support. And I have a billion files on it, too many to move to another server. I'm stuck with them.

I'm trying to install a php program that has a self installer. The program cannot logon to the data base:

Warning: MySQL Connection Failed: Access denied for user: '[email protected]' (Using password: NO) in /usr/local/plesk/apache/vhosts/mgwebsites.com/httpdocs/login/config.php on line 11

Warning: MySQL: A link to the server could not be established in /usr/local/plesk/apache/vhosts/mgwebsites.com/httpdocs/login/config.php on line 11

User paths I am adept to. And I understand perl and its opening path e.g. /user/bin/perl......

The php script calls for me to enter info close to that of perl. What do I put into these fields?

//[database vars]\\
$server = "xxxxxxxxxx";
$username = "xxxxxxx"; //The username to access your MySQL DB
$password = "xxxxxxxxx"; //The password to access your MySQL DB
$database = "xxxxxxxx"; //Your MySQL DB name
$table = "bbusers"; //Please leave

I can get this info from my hosting provider,if I can provide them with the right questions.



A:Need MySQL Help

You should be able to just ask your ISP for this info. You need server, username, password. You will probably have to ask them to create the database and table, or give you rights to do so.

For more info on MySQL, check out http://www.mysql.com

Read other 2 answers

hey all-

I'm messing with some PHP and MySQL, but I can't get a connection ... here's the code I'm using:



        or die(
"Could not connect: " mysql_error());

    if (
mysql_create_db("db_test1")) {

        print (
"Database created successfully\n");

    } else {

Read more

A:PHP 4.3.4 and MySQL

Read other 10 answers

Hello, I want to use php to sort through multiple tables in a mysql database and have them be in order by a certain field. However, I can't seem to get it to sort through multiple tables. As of now it prints out the multiple tables in order, but doesn't mix the results together in the tables. Here is the code:

function db_connect(){
$hostname = "*****";
$username = "*****";
$password = "*****";
$dbName = "******";

mysql_connect($hostname, $username, $password) or die("DB connection unavailable");
mysql_select_db( "$dbName") or die( "Unable to select database");

function search_db($usertable){
//query details table begins
$sql = "SELECT * ";
$sql .= "FROM $usertable ";
$sql .= "ORDER BY `Player` ASC LIMIT 0, 30 ";

$result = mysql_query($sql) or die("Query failed");

while($row = mysql_fetch_array($result))

print ("<tr>");
print ("<td>$variable1</td>");
print ("<td><div align=center>$variable2</div></td>");
print ("<td><div align=center>$var... Read more

A:php/mysql help

Read other 10 answers

hi, i have made a database, and have this. the database is called robsprig_gallery and the user is called robsprig_gallery and the password is example pass1234.

this is what i want editing, ive tried to do it but all i get is an error

DB Error: Could not connect to the database server (localhost, robaldo_imga2).

* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: db_mysql.php *
* Copyright: (C) 2002 Jan Sorgalla *
* Email: [email protected] *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.1 *
* *
* Never released without support from: Nicky (http://www.nicky.net) *
* *
* ... Read more

A:mysql help!

Your orginal function doesn't provide a host, or user name:

function Db($db_host, $db_user, $db_password = "pass1234", $db_name = "robsprig_gallery", $db_pconnect = 0)Click to expand...

I believe it should read as follows:

function Db($db_host = "localhost", $db_user = "robsprig_gallery", $db_password = "pass1234", $db_name = "robsprig_gallery", $db_pconnect = 0)

You can also define your variables before the function like this:

$db_host = "localhost";
$db_user = "robsprig_gallery";
$db_password = "pass1234";
$db_name = "robsprig_gallery";
$db_pconnect = 0;

Then define your funtion like this:

function Db($db_host, $db_user, $db_password, $db_name, $db_pconnect)

That way if you need to change servers, or databases or anything it's easier than fishing around the code.

Read other 3 answers

Hi There. Anyone of you know how to create a membership system with login, personal message, member registrations, personal configurations, password recovery and others features like friendster. Thanks in advance.

A:MySql And Php

Read other 6 answers

Can someone trusted here install the latest stable versions of PHP and MySQL on my server? I use CPanel and you can access everything there if you want. Many thanks.

PS: Is it possible for you to update CPanel to it's latest version too? My host would do all this stuff but he's really busy and I can't wait till tomorrow, heh.

Read other answers
Q: Mysql

I have a real frustrating problem I cannot fix. I am using Windows XP Sp2. I downloaded a free beta version of MYSQL
vs 5.2.x.x. When I tried to install this program, my computer would not let me install it, so I just decided to delete it by
right clicking on the program and selecting delete - my problem is - some of the program was removed and some
remains and I cannot find anything (uninstallers) to remove them. Since this program never installed it was not listed
in the Add/Remove section of Windows nor anywhere else except c:\program files\Mysql. When I try to delete these
left over parts of the program, I receive the following message:
"Error Deleting File or Folder. Canot delete columns_priv.frm: Access is denied. Make sure the disk is not full or
write-protected and that the file is not currently in use." (I have never heard of columns_priv.frm).
I tried booting in Safe Mode and deleting and using System Restore but neither of these made any differnce. There
must be some way of removing these left over pieces short of a refomat. Here is the full path for MYSQL: c:\program files\Mysql\Mysql server 5.1\Data\Mysql. Each of these are folders in sequence and I cannot delete any of them. Any
help will be greatly appreciated. Thanks, Van


Assuming you are logged in as an admin and it still didnt work:
You could try booting into command prompt mode, and fixing it using the command line. I'm not sure why it would be locked for use, but to be safe you could rename the MySQL directory to something like MySQL_REN, then reboot into normal mode and see if anything breaks. If you're satisfied that things run as they should, delete the folder in normal mode (if possible - failing that, reboot into command line mode and delete the directory that way).

Read other 2 answers

First of all, if this is in the wrong spot, please move it. I assumed this would be correct as i need to know how to delete a system process from my computer so i can install it again ;) Or any other workaround you guys might have for me!

I'm trying to set up a private server for a game and ran into some issues. Rather than sort it all out, I deleted all my files, planning to restart the project (now that i knew what to do and how I wanted it, this was now the easiest way. But this was including MySQL.
Now, trying to reinstall MySQL I recieve the following error:

C:\Program Files\MySQL Server 5.0\bin\MySQL Instance Config.exe

the application has failed to start because
its side-by-side configuration is incorrect.
Please see the application event log for more
I'm asuming this is because "MySQL" is still listed in the system processes, albeit disabled and unable to be enabled because of its lacking files to support it ;)
I know i should have uninstalled it properly, but I was being lazy and now I'm getting my just reward, but I'd really appreciate someone's help in sorting out this mess.

Thanks in advance to whoever can offer some insight on how to tidy things up on my PC!

Read other answers

I recently downloaded MySQL workbench and am unable to establish a local connection to my computer. Can I please have help?


Are you getting an error?

Read other 1 answers

Hello can anyone help me getting with commands to get a cgi script reading a mysql database?


A:mysql and cgi

In which language? Perl?

Read other 2 answers

Looking for help on MySql. If someone is a guru please reply

A:MySql Help

Read other 6 answers

I am using MySQL 5.5 and today I have stumbled on next thing for the first time. I opened mysql database and saw blank screen instead tables, my data and etc. changes. I repeated the procedure, but nothing changed.

Read other answers

which do i use? which is more common in the workplace and where are things going? ps why the sql at the end of both. are they made by the same company?

A:sql vs mysql

Read other 7 answers

hello everyone

me again in more problems.

can u please tell me the way i can connect VB6 and mySQL database on a remote server.

thanks in advance.


A:VB6 & mySQL

Read other 12 answers

2 questions

First, I have php installed, running IIS. PHP does evaluate pages correctly, however if I use a form and have it post to a php page I get errors. It appears to me that none of the variables are coming across to the second page when I click submit on the form. The example I have been following in a book had me create the 4 php files listed here http://toddhisted.com/php toddhisted.com is not the server I am trying to run these on, but this way you can see the code. Why wont my values pass over into the next page? btw sign is the first page to load.

My second question. I have MySQL loaded on this win2k machine, when I open winMySQLADMIN under the ODBC it says it used to say not found. I downloaded the odbc driver from mysql.com and installed it. Now it still says "not found" but under it it lists the information. Is that ok, or is something still not setup right? I have a screen shot of it here. Thanks for anything you might be able to help me with.


Read other 6 answers

Hi all!

I'm currently trying to design an inventory system for my school with PHP and mySQL.

After horus and hours of searching the internet and forums.. Here's my problem:

I have got 2 tables in the database:

equipment_model (description e.g. Toshiba)
equipment_type (type e.g. Monitor, PC, Scanner)
I want to list them in a standard HTML table ordered by the equipment_type.

As you can see, the EQUIPMENT table has a unique id called "equipment_model_id" which corresponds with the EQUIPMENT_MODELS table where the model details are stored.

The problem I'm having is it does not order properly! I either get it to display and duplicate numerous entries, it will output the total amount of items in the EQUIPMENT table, but give them all the exact same model description or god knows what else... just nothing correcT!

I'm pulling my hair out! Here's some idea's I've tried with no luck:

$query "SELECT * FROM equipment JOIN equipment_models GROUP BY equipment.serialnumber ORDER BY equipment_models.equipment_type";

$query Read more

A:PHP and mySQL Getting me down :(

Read other 11 answers

Hi somebody ou there could probably help me. I have free webhosting which enables MySQL databases. These sound like extremely useful things but how do I use them?? WHAT DO THEY DO?? If someone could help on this matter i would be extremely grateful

Q: mysql??

I went to this site and i had an update downloading at the time. moments later the site went from the normal home page to haveing this all over it. Is there something I did or can I fix it? I also can not play movies any longer.
Here it is. any info or help would be very apriciated.

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/admin/domains/watch-movies-links.net/public_html/cfg/cfg.php on line 138

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/admin/domains/watch-movies-links.net/public_html/cfg/cfg.php on line 139

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/admin/domains/watch-movies-links.net/public_html/cfg/cfg.php on line 139

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/admin/domains/watch-movies-links.net/public_html/cfg/class/class.db.3.php on line 118

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/admin/domains/watch-movies-links.net/public_html/cfg/class/class.db.3.php on line 118

Watch Movies New Featured Top Tags Genres Playlists Users Forum Submit Links

watch movies - Archive, Large Collection of Free Full Length Movies.
Watch Video Online, Download Stream Con... Read more


Run Malwarebytes and / or SuperAntiSpyware as a check.Otherwise, is the main link this? :http://www.movies-links.tv/What browser are you using.Clear the browser cache and try again.

Read other 2 answers
Q: Mysql

anybody know anything about MYSQL ? am trying to install a program that needs mysql and am at a loss.


I get a error code 100 mysql unable to open file "bhserverglobals.1bd (errno:1). I have spent hours looking for this file or information on it. Can anyone advise me on how to fix this problem? I get error codes 3 or 4 at a time and every 1 hour or so they pop up . Thanks in advance for your help. My system is XP Pro sp3 desk top. I have adobe version cue C52.

Read other answers

Yea, my friend made a MySQL Database for a The Specialists Role Play Server. I need access to it. I downloaded Query Browser and he doesn't know the hostname or how to give access to me. Can anyone help?

Read other answers

I design MySql databases and PHP sites. My favorite site to hit in the morning is http://www.umn.com. (I am not advertising just thought it might be good to reference the problem) Everything on the site runs fine! Except when accessing artist pages. All my computers but 1 do not have a problem. The one that is having a problem is clean as far as viruses and ad/spyware according to Web Root Spy Sweeper and Norton Anti-Virus Pro 2004. Every time I click on a link to an artist page I get. The quickest way to see an artist page is to click on an act in the Chart on the index page.

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Can anyone help fix this? I found www.techsupportforum.com in the UMN forums http://forums.umn.com/index.php?showtopic=460 so others are having issues as well.

This machine runs XP Pro with 1 gig and 3.2 GHz

Mozilla is cool, no probs! But Nutscrape and Exploder are having issues. There are other sites I am having problems with as well with this computer.

Read other answers

hey all,
i wasnt sure where to post this so i put it here

i just downloaded and installed MySQL Max 3.(something) to use with phpBB2 to test MODs before i upload them to my site. now when ever i shut down my computer, when i turn it back on i need to entirely delete the phpBB database and delete the file and re-unzip them

why is it doing this and how can i fix it??


A:MySQL help

Read other 6 answers

I have this script that checks if the username and password are correct for a login to my site..but its giving me all kinds of errors like:

Parse error: parse error, unexpected $ in /home/public_html/myfile.php on line 45

Heres the code:

<title> Welcome</title>

if (empty($username)) { die(" Please enter your username<br>"); }
if (empty($password)) { die("No password has been entered<br>"); }
if ((strlen($password) < 5) || (strlen($password) > 10)) { die("You password is to short or to long"); }



$connection= mysql_connect($host,$uname,$pass)
or die("Database connection failed");

or die("Database could not be selected");

$query="SELECT * username,password FROM login WHERE username='".$username."' AND password='".$password."'";

$result= mysql_query($query);


if(!($username) == $row["$username"]) { die("Your username is incorrect, please try again");

if(!(md5($password) == $row["password"])) { die(" Wronge password, please try again");

else{ die(" User does not exist!"); }

<?php include'header.php';... Read more


Read other 7 answers
Q: Mysql

Hi Everybody,

I hope that this is the right forum for this topic... if it isn't I would hope that a moderator would move it to the right forum.

About a year ago I was experimenting with Apache, MySQL, and phpMyAdmin, trying to figure out how to get those thing to work. I finally uninstalled all of it, and deleted all of the files, and folders that were associated with each of those programs.

Well, I've just decided that I want to give it another, so I downloaded MySQL and was trying to get it setup. I hit a snag near the end of the installation and got a message saying that if I had uninstalled a previous installation of MySQL that its password file wasn't automatically uninstalled or deleted along with it, and that I'd have to delete it manually.

As I have no idea what the heck I'm looking for, or where it's hiding, I have to ask; Has anyone out there done this before? And where the heck is that file that I need to get rid of hiding?

Thanks for any advice.

♥ Wendy

Read other answers

Dear folks,
i am working on a big project in C#, part of the project is a seperate exe ffile that receives mysql queries and execute them.
I need to design that exe file, i dont need the traditional DLL addons that use functions to do queries. in other words i dont want to analyze the query and then apply function such as .Connect, .Select and etc... as the options for such an analysis are infinite.
i need something that performs a query as it is.
is it possible?
any help would be appreciated

A:C# and MySql

I'm really having a hard time figuring out what you're trying to ask. Could you give a bit more detail about what it is you're asking about?

Read other 2 answers

these are the errors i am receiving:

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 7 in /home/paidntra/public_html/louis/bubble/report.php on line 39

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 8 in /home/paidntra/public_html/louis/bubble/report.php on line 41

these are the lines:

$first_spend = mysql_result($res,0,0);

$last_spend = mysql_result($res,0,0);

anyone got any ideas?

A:php & mySQL errors

Read other 9 answers

I'm a designer, my talent is more or less limited to the order of creativity first then programming, lol... As such, I have a lot of work to keep me busy JUST designing static brochure-type sites (hey, that's all the client wants sometimes) Right now, I've got myself in a bit of a jam and don't have alot of $$ to work with. I have a client (specifically speaking--a chamber of commerce) in need of being able to do updating the site's member directory records on their own (maybe even the end user updating their own record) and I need (think Tony Soprano) "youse guys's" advice.

I have access to an Excel spreadsheet that has all the necessary records on it that we use for our membership directory. When I export this to a plain delimited .txt file and upload it to the server as a table that's as far as I get with it! A table, yipee! I know NOT how to characterize each record and type of field, etc. as per the 50-odd pages of the official PHP and MySQL web sites dictate, nor do I care to. Whenever I go through the official documentation on programming sites I always end up reading for hours and then going to back to square one....which is go to school for programming. No time, other work to do! Maybe later!

Given my limited programming knowledge/interest I am finding it difficult researching to find a product that is capable of such tasks. I KNOW there's one out there, I'm just in need of some recommendations from the industr... Read more

A:Help recommending a php/MySQL app

If you want a nice front-end for MySQL, try phpMyAdmin. It allows you to create (nearly) every part of your MySQL database through your browser.


That should make using MySQL easier to use. I don't know if it'll help you, but what the hell...

Read other 2 answers

I'm just reinstalling my test server here, and I've hit a minor snag. I've installed the latest apache with PHP5 and MySQL5. I'm trying to install phpMyAdmin now, but it's having none of it.

The error I'm getting from phpmyadmin is

Cannot load mysqli extension. Please check your PHP configuration. - DocumentationClick to expand...

Obviously I've neglected something or screwed up somehow, but I'm at a loss as to where. Could anybody give me some manner of checklist for this issue, or simply the answer if it's obvious to you, because clearly, it's not so obvious to me

Edit: Oh god!. now it won't even load phpinfo. There's no error message, and I know php is working because phpmyadmin reports the error.

This is just nuts.

A:PHP/MySQL server help.

What OS are we talking about here? You are probably missing some PHP components. Like the mysql part of it. In Linux or such, you should look for a "php-mysql" or simlarly named package.

Read other 7 answers


I need mysql server running, so i downloaded all 3 applications from this website http://dev.mysql.com/downloads/mysql/5.1.html#win32 and installed them all. In all of these cases installation goes smoothly but when it comes to configuration part i do the following steps
first step
second step
third step
fourth step
fifth step
sixth step
seventh step is language preferences...
8th step
9th step
10th step- error
I have 2 routers with firewalls and im running XP Please help me solve this problem.

A:Mysql 5.1 problem

Did you correctly fill in the options on Step 9? If not, fill them in and try again. Als0 make sure you're logged in as an Administrator before running the install.

Read other 1 answers

i recently installed adobe creative suite, and about a week after doing so i am now begining to get an error message saying:

mysqladmin.exe - Application Error

The instruction at "0x1000a73f" referenced memory at "0x00000028". The memory could not be "read".

Click OK to terminate the program

if i click okay it intantly opens itself again, and i really would like to be rid of it.
i tried reinstalling adobe creative suit, teh n taking it off completley, nothing
i even restored my computer t ofactory settings, then reinstalled it, and i get teh error.
please help, and thanks in advance 'cause i know sooner or later one of you smart folks will have some sort of answer

A:Mysql Error

you can close this topic, i figured out the problem

Read other 2 answers

I have the query like this.

select a.employee as vvEmpNo, sum(Empvalue) as vvEmpvalue, count(Employee) as vvCount
from Employeetable a left join worktable b
on a.employee = b.empno
group by a.employee
order by a.employee

Wel i have 200 employees in the EMPLOYEETABLE and 70000 records en the Worktable..

This query hangs on me....i dont know why..

the Worktable looks like this.

empno, value, balls, date

Emp1, 200, 6, 23/07/2007
EMP1, 4, 1, 17/07/2007
EMP2, 500, 700, 27/07/2007
EMP2, 0, 0, 20/07/2007
EMP2, 234, 212, 22/07/2007

What i want is this

There will be 63 fields.1st field the employeeno then the rest the days of the month

EMP1, DAY1 TOTVALUE, DAY1 TOTBALLS, DAY2 TOTVALE, [email protected] TOTBALLS [ETC until 31 days]

EMP2, DAY1 TOTVALUE, DAY1 TOTBALLS, DAY2 TOTVALE, [email protected] TOTBALLS [ETC until 31 days]

Can someone help me please. I have written a procedure to put everything in a 3rd table as well but that takes up to 45 minutes to do.

Read other answers

Can someone trusted here install the latest stable versions of PHP and MySQL on my server? I use CPanel and you can access everything there if you want. Many thanks.

PS: Is it possible for you to update CPanel to it's latest version too? My host would do all this stuff but he's really busy and I can't wait till tomorrow, heh.

A:PHP, MySQL Installation

Read other 9 answers

I have been following the tutorial below in order to install mysql 5.0 onto a machine running Windows XP S.P 2.

The installation goes exactly as described, with no problems.


I also want to install the same software onto another machine running Windows 98 S.E, and all seems to go as described until I reach step 18 of the tutorial, at which point the option to 'install as windows service' is not available. When I reach step 19, there are no options to include security settings or passwords.

The installation completes at stage 22 by saying that it was a success.

However, in view of the differences during installation, will this installation actually work the same as my XP installation?

Should I upgarde my O/S on the 98 machine, or is this really necessary?

Any constructive suggestions welcomed.

A:Mysql 5.0 0n Windows 98 S.E?

Should I upgarde my O/S on the 98 machine, or is this really necessary?Click to expand...

You haven't provided any information about what you're trying to do on the machine (other than run MySQL) but nonetheless I would highly recommend updating the machine to a newer operating system.

Read other 2 answers

can someone put this in english for me LOL:

Paste the contents into a tool that can execute SQL commands for your database

every otherphp script i've used just said change your variables and run the install so i don't have any clue what this means

A:mysql tool???

Read other 6 answers


im having problems getting a forum running using MySQL

its a phpBB2 forum and the latest of MySQL

im Running WindowsXP SP2

Apache through PHPTriad 2.2

I can see the forums through localhost but visitors just get a page cannot be displayed

any help would be great


A:MySQL forum

Read other 6 answers

how to start mysql does anyone know?

A:Starting MySQL

If you have a web host that provides mysql service, then likely you can logon to the Host site and use an online tool know as phpMyAdmin to set up your database parameters. At least that is how it worked for me.

Read other 3 answers

This is what I'm seeing:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/louissei/public_html/rotator/admin.php on line 349

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/louissei/public_html/rotator/admin.php on line 350

Other than this error showing at the bottom of the page the script seems to be working fine so far.

These lines read:

$standard = mysql_fetch_row($result);
$premium = mysql_fetch_row($result);

The script is for a membership based site and these lines are referring to the membership type. If this error wasn't showing in the admin area I would supply a link but I'm not about to give out my password! LOL




Read other 1 answers

Is there a significant difference between MSSQL and MySQl? I need to learn MSSQL but when I search for tutorials and books there seem to be a lot more out there for MySQL.

For example, are the basic commands the same? Any tips on getting started?

Thanks much!


I believe both use similar SQL languages and you could use queries from one on the other with little modification.

Microsoft uses T-SQL language which is a little different.

Useful link (MySQL): http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html - MySQL is free

Useful link (MS SQL):
http://www.microsoft.com/sql/msde/default.mspx - you can get the MSDE for free and practice with it

Read other 2 answers

i want to know how to make a connection to MYSQL using php code

please send suggessions



A:connection to MySQL

If your not sure on how to connect to a mysql database then dont do it, learn a bit of PHP and sql....

Also make sure your server has php and mysql enabled...

Read other 3 answers

I'm still searching on google, but I can't find anything which helps:
I'm new to php, mysql etc.
Have finished installation but now trying to configure.
I have successfully installed with mysql --install at the command prompt.
Then I need to do NET START MYSQL:
... but I get an error.
It says the service is starting then says it could not be started, a system error has occurred (called 1067). Any ideas? It looks quite common when I search for it on google but I cannot find a solution!

Here is the full blurb:

The mysql service is starting.
The mysql service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

A:MySQL won't start

I think I've done it. I restarted the pc and it seems ok.

Read other 1 answers

I have set up mysql and uploaded all my .cgi files to my server.

My config.cgi file is setup but...
My mysql.cgi is setup but...

when i try to access my mysql.cgi webpage I get:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/1.3.34 Server at [webpage} Port 80

This may be due to a syntax error ... is there
any syntax error in the following?:

IN MY config.cgi file:

sub Db_Connect{
use DBI;
$DSN = "DBI:mysql:$sql_db_name$sql_hostname$sql_port";
$dbh = DBI->connect($DSN, "$sql_user", "$sql_pass") || die "Can't open MySQL! Please make sure you have your MySQL Login, Database and Host information set correctly in the \"config.cgi\" file before running this script! If you are not sure of your MySQL information contact your webhost to obtain it. You CANNOT use any of these safelist scripts unless you have MySQL running correctly on your site and know your MySQL login information.\n";

sub... Read more

Read other answers

My first thread and I must explain that I would be considered a novice at computing.My problem is the message - MySQL Server cannot connect to .....( at server name(.....).
I have Googled for a solution but I am afraid the high tech answers do not really make any sense to me.One simple solution was to open task manager and see if the program was running.There was no MySQL program listed in the task manager.Is this the name of the program in the task manager?or does it go under another?
I would be very grateful for any help that a novice may be able to follow.

A:MySQL Server

SQL server is a Microsoft database program. Are you currently using SQL (Sequel)?

Read other 11 answers

Hi guys, Im having a problem of getting this database to work.
Heres The Ouput im receiving when trying to use the database:

ERROR 1064 (42000) at line 55: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Players'
INSERT INTO Players VALUES (1, 1, 'Erik', 'Bird', 'RHP', 1, 74, ' at line 9

And Here is the section of code around the area of the error:

PlayerID int(2) NOT NULL default '0',
TeamID int(1) NOT NULL,
PlayerFirstName varchar(30) NOT NULL default '',
PlayerLastName varchar(30) NOT NULL default '',
PlayerPosition varchar(3) NOT NULL default '',
PlayerNumber int(2) NOT NULL default '0',
PlayerHeight int(3) NOT NULL default '0',
PlayerWeight int(3) NOT NULL default '0,
PlayerBatThrow varchar(4) NOT NULL default '',
PlayerClass varchar(2) NOT NULL default '',

-- Dumping data for table 'Players'

INSERT INTO Players VALUES (1, 1, 'Erik', 'Bird', 'RHP', 1, 74, 215, 'R/R', 'Fr');
INSERT INTO Players VALUES (2,1,'Andrew', 'Brown', '1B', 2, 72, 195, 'R/R', 'Jr');
INSERT INTO Players VALUES (3,1,'Brandon', 'Buckman', '2B', 3, 77, 225, 'L/L... Read more

A:mySQL Coding Help

Hi Scarface23,

This should work :

INSERT INTO Players VALUES ( '1', '1', 'Erik', 'Bird', 'RHP', '1', '74', '215', 'R/R', 'Fr' );

It may look weird but numeric values must be enclosed with quotes too !

Read other 1 answers

Hi. This may be a question which you might not be able to answer. I'm working on a SQL 2000 server with code that is written specifically for a Windows box. However, about 10% of the machines on campus are Mac's and I have written code to alter the logins daily around the nightly forced update from the Unix based network.

I have heard that there is some code that will identify if the machine that the user is on as a Mac or PC and alter the login's as necessary to grant the user access.

If the logins are left alone, the Mac fails to understand the complete login name which is recognized through LDAP authentication and characters are missing. Is is possible to put in MySQL code that would identify if a user is on a Mac or PC prior to LDAP authentication and if you, do you know it?

Read other answers