pripojenie na MySQL

incredible · Napísal **incredible**: 01.04.2009 18:36

Začínam sa učiť databaze a nemozem sa pripojit:

Kód:

<?php 


if ($_SERVER["SERVER_ADDR"]=="localhost")
{
  define("SQL_HOST","localhost");
  define("SQL_DBNAME","database");
  define("SQL_USERNAME","user");
  define("SQL_PASSWORD","password");
}
else
{
  define("SQL_HOST","mysql.nekde.cz");
  define("SQL_DBNAME","databaze_u_providera");
  define("SQL_USERNAME","user2");
  define("SQL_PASSWORD","password2");
}


mysql_connect(SQL_HOST, SQL_USERNAME, SQL_PASSWORD);
mysql_select_db(SQL_DBNAME);
mysql_query("CREATE TABLE zamestnanci(jmeno varchar(10),prijmeni varchar(15),cislo int,datum_narozeni date)")
or die("Nelze vykonat definiční dotaz: " . mysql_error());

?>

Vypíše mi:

Citácia:

Warning: Can't connect to MySQL server on 'localhost' (10061) in c:\apache\htdocs\sql.php on line 29

Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in c:\apache\htdocs\sql.php on line 29

Warning: Can't connect to MySQL server on 'localhost' (10061) in c:\apache\htdocs\sql.php on line 30

Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in c:\apache\htdocs\sql.php on line 30

Warning: MySQL: A link to the server could not be established in c:\apache\htdocs\sql.php on line 30

Warning: Can't connect to MySQL server on 'localhost' (10061) in c:\apache\htdocs\sql.php on line 31

Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in c:\apache\htdocs\sql.php on line 31

Warning: MySQL: A link to the server could not be established in c:\apache\htdocs\sql.php on line 31
Nelze vykonat definiční dotaz: Can't connect to MySQL server on 'localhost' (10061)

Neviete čo robím zle?

Tominator · Napísal **Tominator**: 01.04.2009 18:58

zdá sa že na localoste ti nebeží mysql ... daj si phpinfo a nájdi tam MYSQL .. pak napíš výsledok ...

incredible · Napísal autor témy **incredible**: 01.04.2009 19:15

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.39

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited

o sql tam mam naisene toto. da sa s toho nieco vycitat?

Tominator · Napísal **Tominator**: 01.04.2009 19:36

že ti to php podporuje ... ok a inštaloval si MYSQL? Aký tip inštalácie MYSQL máš? (Wamp, Xamp, manuál?)

stenley · Napísal **stenley**: 01.04.2009 21:30

mne sa zda, ze mysql ti ani nebezi

incredible · Napísal autor témy **incredible**: 01.04.2009 21:39

mam nainstalovany PHPtriad ktory obsahuje apache,php a mysql. V priecinku apache mam priecinok mysql/bin s nejakymi exe subormi. Takze MySql by som mal mat.

incredible · Napísal autor témy **incredible**: 04.04.2009 12:55

chcem si znovu stiahnut mysql a doklikal som sa sem http://dev.mysql.com/downloads/mysql/5.1.html#win32
Co s thoto si mam stiahnut?

Windows downloads (platform notes)
Windows Essentials (x86) 5.1.33 35.5M Pick a mirror

Windows MSI Installer (x86) 5.1.33 107.4M Pick a mirror

Without installer (unzip in C:\) 5.1.33 115.6M Pick a mirror

stenley · Napísal **stenley**: 06.04.2009 14:19

ak chces klasicku instalacku, tak Windows MSI Installer

incredible · Napísal autor témy **incredible**: 06.04.2009 14:52

aha takze to su len typy insztalacii, som myslel ze to su nejake verzie alebo co

pripojenie na MySQL

Podobné témy