Connecting PHP With MySQL
I wanna connect a php document with mySql. So i write the following code...:
$link = mysql_connect("127.0.0.1:3306", "HostName", "Password");
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
I have tried this instead of 127.0.0.1:3306 with localhost but the result i get is:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:ServerApache2htdocsPHPFILEsmyfirst.php on line 51
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have MySQL 4.1 and i do not know what to do!
Please help me i am in great need thank u. I would appreciate it if u mailed me also.
View Complete Forum Thread with Replies
Related Forum Messages:
Connecting To MYSQL From VC++ 6
I'm looking for some assistance in using Embedded SQL in C using VC++ 6.0 to connect to MYSQL in Windows XP. This is new to me, but it is my understanding that I need to use a precompiler. I'm confused about where to get the precompiler. Can someone explain in simple straight forward terms what I need in order to do this? I've been Googling for hours with no real answers.
View Replies !
Connecting To MySql DB From A .NET App
I'm developing a Windows application in C# using Visual Studio 2005. The application should be able to read data from a MySql database. I've developed applications that read data from a Microsoft Sql Server database, using the System.Data.SqlClient namespace. My question is, does this work for MySql? And if not, what should I use? I want to keep my database connectivity simple, only executing querries and maybe stored procedures.
View Replies !
Connecting To Mysql Using Asp.net
I want to connect to mysql 4.1 db using asp.net.I havent done this before but according to book im using it says all i need is the database provider name (like the provider name for ms access is something like microsoft.jet.oledb....)-i used the myodbc before with asp(which didnt work but thats another story) but the book doesnt mention anything about odbc...yet in the mysql manual it talks about the using the myodbc to connect with asp and asp.net So the question i have is do i just use the same obdc driver i downloaded for use wih asp....or is the book right and if so does anyone have any idea what the mysql provider name is?
View Replies !
Connecting MySql To VBA
I am asked at work to connect MySql database to excel through VBA (macros)..how do i do this, does anyone knows a tutorial or somehitng like that, I have prety much created a code, but it does not through me any data back..
View Replies !
Connecting DMW With PHP/MySQL !!!
When attempting to test the connection to a MySQL database within a PHP site in Dreamweaver, the following error occurs: An unidentified error has occurred. I have installed Mysql 4.1 and php 5 and run dreamweaver MX with an apache web server. If i create a simple php info() page it pops up fine so the server is fine and so must php. I can log into my Mysql database and select tables etc, so that's fine. But i just can't get Dreamweaver to connect to the database. I get a 'unidentified error' message something to do with the selectDatabase.js.
View Replies !
Connecting To MySQL From PHP
I'm newbie in the world PHP-MySql and I have a problem when I try to connect with my DB form a PHP script. With the instruction mysql_connect('localhost', user, password) I get the error: Fatal error: Call to undefined function mysql_connect in 'my phpscript'
View Replies !
Connecting To MySql DB From Different PC
I just made a test with mySql on Windows NT. I created a table with different fields, and I made a Java program to connect with JDBC to that DB. It works if I connect from the same PC where mySql DB is. I used this Java sentence to connect: .....DriverManager.getConnection( "jdbc:mysql://localhost/...... And it made the query I want. But I would like that a PC in Internet could connect to that DB. I suppose I must put the IP of the mySql server instead of "localhost" on that sentence, but I got this error: java.sql.SQLException: Invalid authorization specification: A cess denied for user: 'a@cable87a004.usuarios.retecal.es' (Using password: YES) I think I should change something on Winmysqladmin at bind-address (my.ini Setup) ?...I have tried to uncomment bind-address and write the IP of the mySql server, but it doesnt work...
View Replies !
Connecting To A MySQL DB With .NET
I was looking to create a VS.NET program that can connect to a MySQL database on a Linux server. I see that MySQL has some projects that integrate .NET with MySQL but my question is are those projects restricted to using MySQL on a Windows OS or can my program, on a Windows OS, connect remotely to MySQL, on a Linux OS?
View Replies !
Connecting To MySQL With PHP
Originally Posted by tluther I am new to MySQL & PHP. I am following samples in book by Kevin Yank on how to connect to MySQL with PHP. I have installed Apache, MySQL 5.0 & PHP 5.2 and am attempting to run as local host. When following the lessions in the book everything was working ok until I tried to connect to MySQL. In the PHP script I am using localhost as the address, root as username and the same password I use when I open MySQL through the command line clinet. I have been able to create and modify a sample database but just can't get PHP to connect. Any suggestions would be appreciated. I will be glad to email you the script I am using to try to connect if you need it. This is the code I am using: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Our List of Jokes</title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> </head> <body> <?php // Connect to the database server $dbcnx = @mysql_connect('localhost', 'root', 'mypasswd'); if (!$dbcnx) { exit('<p>Unable to connect to the ' . 'database server at this time.</p>'); } // Select the jokes database if (!@mysql_select_db('ijdb')) { exit('<p>Unable to locate the joke ' . 'database at this time.</p>'); } ?> <p>Here are all the jokes in our database/p> <blockquote> <?php // Request the text of all the jokes $result = @mysql_query('SELECT joketext FROM joke'); if (!$result) { exit('<p>Error performing query: ' . mysql_error() . '</p>'); } // Display the text of each joke in a paragraph while ($row = mysql_fetch_array($result)) { echo '<p>' . $row['joketext'] . '</p>' } ?> </blockquote> </body> </html>
View Replies !
Connecting To MYSQL Via MS Access
I have recently decided to start using MYSQL instead of MS Access 2003. After reading through numerous articles i have learnt that i can use access as a GUI for making changes etc to the MYSQL databases. My problem is that i am unable to set this up correctly. give me a set by set guide on how to do this or give me a link to a site or post that outlines how to do this. i have searched google without much luck at this point. I have attempted to use the odbc method but i do not know what to browse for when the wizard prompts me to browse. i have never use this method before.
View Replies !
Connecting To MYSQL From JAVA
i need to connect to a MYSQL database from a JSP... so i believe that if i learn how to connect to the MYSQL database through java... i can use the same method to connect through a JSP... anyways my question is does anyone know how to connect to mysql through java.
View Replies !
Connecting To Mysql Vi ODBC
I'm trying to connect to a remote mysql database via odbc but for some reason I keep getting the following error in the odbc panel Code: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '69.65.107.209' (10060) I added access to % in mysql access host for now to see if it might just work this way... but for some reason I can't get it working.
View Replies !
Error Connecting To MySQL
hey guys im getting this message when trying to installa classified ads script that i got? Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View Replies !
Connecting Php To Mysql Version 5
My problem is,am trying to connect php with mysql so that i can write to the database and also read from the database in de mysql server. I tryed to use the function mysql_connect(),but i get a message like "Call to undefine function mysql_connect()" in the browser. I have mysql and php on de same computer. I think i must make some changes in the php ini file(the configuration settings) but i have no idea how to accomplish it. And also which username must i use in the function since i don't use any username when connecting to mysql or i should leave that argument empty?
View Replies !
VB6 - Connecting To A MySQL Database
I know how to connect to and access MS Access databases with VB6, but I'd really rather use MySQL. Can anyone tell me where I might be able to find a VB6 code example of how to connect & access a MySQL database?
View Replies !
Connecting To MySQL In Localhost
I am totally new to php and i am using Dreamweaver 8. I am trying to create a page to initiate connection to the MySQL Server 5.0 at localhost, but the browser returns me this error message: "Fatal error: Call to undefined function mysql_connect() in c:InetpubwwwrootMy_PHPconnect_to_mysql.php on line 11" The testing code i was trying as below: <?php $connection = mysql_connect('localhost', 'root', 'password'); if (!$connection) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($connection);
View Replies !
Connecting To MySQL Through Dreamweaver 8
I'm taking an online class in php, and am trying to follow a tutorial that is supposed to teach me how to connect to MySQL through Dreamweaver. I get to the part where I'm supposed to click the + sign on the databases tab, which brings up the MySQL Connection box. I type in my connection name, username and password (the tutorial says not to type in the server, because it should be able to find it itself, although I've tried it both ways) and when I click the "select" button to make it find my database, I get this error message: "can't connect to local mysql server through socket '/usr/local/mysql-5.0/data/mysql.sock'(2)" I'm not running a firewall, and I'm pretty sure I have everything set up correctly, but I may be wrong.
View Replies !
Connecting To MySql On An XP Machine
I have worked with mySql on my localhost and it does fine. Now I am going to try and login to it from another XP machine. Both machiens are Windows XP Pro SP2. What do I need to type at the command prompt to login to mysql on the other XP machine?
View Replies !
Connecting To MySQL From A PHP Script
i have installed the latest version of MySQL, and Wordpess, a PHP-based blog. Wordpress has a config file where you set the db name, user name/password, and host name (in this case, 'localhost'). In the past, I have simply input those variables and proceeded with the Wordpress install with no problem. This time, however, it's not working (I get this message: "Error establishing a database connection.This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down."). I know the database exists,I know the user name and password are correct,and I know the user has the correct rights,because I gave that user *all* rights.I suspect that there is a flag or option I need to set to allow PHP to connect to the db from a web script. I start the server by manually typing: /usr/local/bin/mysqld_safe & Looking at the .err file doesn't show any unusual activity. Any ideas? Is there "extra" stuff to do to allow internet connections?
View Replies !
Problems Connecting Mysql With Php
I'm building a PHP website with MySQL databases under windows xp, and i want to know how can i verify that MySQL is comunicating with PHP because the script i got says that there's an error connecting to the database.
View Replies !
Connecting To A MySQL Database
I'm trying to connect to a database from an ASP.NET page with VB.NET scripting on it. How can I do this? More specifically, what's the VB.NET code for connecting to a database?
View Replies !
Connecting Mysql Tables Together
I was wondering if you guys could give me a good idea on how I can connect two tables together in mysql. And also with mysql_query how I would insert in the id number for those two tables. I'm just really kinda confused really on how it works.. But I'll tell you want I do know. Basically I know that in mysql database the tables that you want interact with each has to have one column thats the same. What I don't know is how it really works. Example: Say that I have two tables in mysql database, and one table is called 'users' and the other is called 'user_post' I know pretty much that say for example in each table I would have a column called something like user_id, ok says that the user_id is a primary_key, so when a person goes to register them self and I use a mysql_query such as the follow: mysql_query("INSERT INTO users (``, `username`, `password`) VALUES('', '$username', '$password')") or die('Datebase error: ' . mysql_error()); that would only bring the value in the user table to 1, seeing that the value was at 0. So my question is how do I connect the two together if when I go: mysql_query("SELECT user_id FROM user_post WHERE id = '" . $_GET['id'] . "'") or die('Database errror: ' . mysql_error()); When the user_post id is still at 0. I'm sorry if I didn't example this good enough, and if you have any question then just ask me.
View Replies !
Problems Connecting To MySQL From PHP
I'm having a hard time figuring this one out... I'm trying to connect to my MySQL server with the 'mysql_connect()' function but I keep getting "Fatal Error: Call to undefined function: mysql_connect() on line 125." The code worked perfectly on my desktop but as soon as I tried using my laptop I get this error. I can't remember what version of PHP I'm using on my desktop (either 4.2.3 or 4.3.0), but my laptop has version 4.3.3. I'm been searching the forums and php.net for an answer but I'm not having much luck. Obviously the version of PHP doesn't support the 'mysql_connect()' function, either because of deprecation or because PHP is not set up to support MySQL.
View Replies !
Connecting To MySQL/phpmyadmin
I am trying to get phpmyadmin working, i've have downloaded it and put it in the directory that i use to run files on the server. When i go to http://localhost and then phpmyadmin. It comes up with this error: Error MySQL said: Can't connect to MySQL server on 'localhost' (10061) Well this is pretty slef explanatory but i don't know how to connect. I think you need a password and username but i don't know them.
View Replies !
Connecting To MySQL Database
I have a windows program that retrieves and stores information into a mysql database. I ran this program a couple of months ago without a problem but now when I try to run it I cannot connect to my database. What all do I need to make a windows program connect to a mysql database? So far I have downloaded the MyODBC driver. Also I am able to connect to the database via webpages. Is there anything else that I would need besides that MyODBC driver? I do have the right port(s) open also...
View Replies !
Connecting To MySQL From Another Server
I have two sites. They are on two separate servers that I both control. However, when I try and connect to mysql from another site, it does 'Host so.and.so.com is not allowed to connect to this MySQL Server.' How can I make it so so.and.so.com is allowed to connect? Is there a command through shell that I can run to allow host so.and.so.com to connect?
View Replies !
Connecting To Mysql For The First Time!
Just learning from a php/mysql book, really getting through it ( the larry ullman visual quickstart one) and i left it on the train on the way back from london! IM gutted Could anyone help me lessen the blow and help me with how to connect to mysql from an installation of mamp via the terminal. I dont have a clue what the path to it is and then im a little confused as what i need to do with all the -u root -p stuff. Could anyone give me a little run down? the reason i chose mamp becuase it thought it would get me off the ground quicker, now ive lst my book its put me back a good half a week!
View Replies !
Problems Connecting To MySQL With Php
i am new here and have been doing webdesign for a while now and i thought its about time to give MySQL and php a go; so i bought this book (build your own database driven website using php+mysql by kevin yank) but i am having one or two problems I can connect to the mysql server fine using the client programe and the command prompt and make tables etc etc, but when i try to connect to it using php then the trouble strikes it just donst want to work. I have opened all the ports etc everything seems to work fine until i try and connect to it using php i am using this PHP <?php mysql_connect(ྎ.32.144.96', 'root', '********'); ?> and this error comes up: PHP Fatal error: Call to undefined function mysql_connect() in C:WEB_ROOTphptestssql.php on line 2 (btw line 2 being: PHP mysql_connect(ྎ.32.144.96', 'root', '********'); ) if you need any more info on this please ask me and i will give it to you asap! please help me on this i really would like to advance but i cant with no MySQL! or can you point me to a free web host that would offer me a MySQL server for me to use, with the code
View Replies !
Connecting To Mysql In Mamp
I have a wamp installation on a pc running windows 2000; development partner has mamp installation running under os/x. His installation has mysql allowing me to login from anywhere. When I try, no matter how I try, I get mysql error 2003 - access denied. I am stumped. I am not even sure which things would be different. I have noticed, when I try to use phpmyadmin - which is on both machines - that the client and server versions are different. Can anyone help point me in the right direction?
View Replies !
Connecting To Mysql From MSAccess 2000
I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS = Excel. However, it returned the following error when I tried to link = some Mysql tables from Access 2000: ODBC--call failed. [MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for = user: '@<my ip address here>' to database 'tradingdata' (#1044).
View Replies !
Connecting To MySQL From Excel Through ODBC
I'm trying to access my MySQL db, hosted by my ISP, from my local Excel application. However, I don't know how to have the ODBC to connect with the db. It doesn't recognise the server name. Here is the info I received from the ISP: Host: localhost Database: dainville_be User name: dainville_be And of course, the password. Obviously, "localhost" is not enough to locate the db from the local ODBC connection... How should I proceed?
View Replies !
PHP/MySQL, No Longer Connecting To Db When In Function
I'm trying to clean up the code so that design changes will be easier. So, I've put the $connection = mysql_connect($hostName,$username,$password) or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db($databaseName, $connection); etcetera... with output commands in global functions(). But for some reason (why?), it no longer "reads" the original include with all the database variables. Is there a way to help these new functions "read" the previously set variables?
View Replies !
Problem Connecting To MySQL Server!
I have a problem connecting to MySQL server! The server is working on the other computer than my scrpit(my web page). The IP of MYSQL computer is 10.0.0.2. and port 3306! When i try to connect like this : $link=mysql_connect("10.0.0.2.", "user", "password"); $db ="database_name"; ... I get the folowing massage: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '10.0.0.2' (10061) in D:InetpubwwwROOT....... The ip, username, password and database name are all correct! It is said, that it's possible, that the MySQL is set to work on localhost! If this is the problem, where to configure mySQL, to be able to connect from other computer?
View Replies !
Connecting Computers On The Network To The MySql
I used mysql for a while, I have it installed on my machine and it's a great product. I need help as I am developing an application with php and mysql. and I want to install this on a windows server or just NAS network storage device so other users on the network can run this application and of course use the mysql to store information. I need real help as I am not really familior with installing on a windows server and the required setting to allow different users on the network to use the application and store on the same datatbase.
View Replies !
Connecting To Mysql Server On Windows
I am trying to use mysql on win98 I downloaded mysql control center. I fill out the info it asks for and it shows it registers the the server but then I cannot connect to setup my db. heres the info I put in. name:upload host:localhost username:root password:****** Ihave tried stopping and restarting everything. I used the default install settings for mysql.
View Replies !
Connecting Remote Server In Mysql
Waht is the way to connect the remote database in mysql? right now i am connecting it with localhost as server name but if i want to connect other datasource it showing the error datasource not found.
View Replies !
Connecting To A Remote MySQL Server
I havn't done this before and i'm not sure how to do it. I have another computer on a LAN that is running a mysql server and is the machine that is also running the intranet server which i am working on. What i want to know is how to connect to this server from my MySQL console so i can administer the databases without having to be in the main machine. I thought it would be as simple as using the IP address but this doesn't seem to do it. Can i connect annonymously like i can from the host or do i have to have a user account setup?
View Replies !
Connecting To Remote MySQL Problem
I set up a linux server for Apache, PHP and MySQL last night. A problem remains. I can't connect to MYSQL with MySQL Administrator running on another machine. The error says I cannot connect 'hostnamt' of the machine I am on. I can connect via command line on the linux server, and I have added entries in the user table specifying host as '*' with the account I am trying to use. I flushed privileges and even rebooted the machine. Is there some global setting that I must change to allow remote connections?
View Replies !
Connecting To Remote Mysql Using Mysqladmin
I think Idid this before but cannot remember what i did. I want to use mysql admin to connect to remote mysql server as localhost so I can set server side features without having to be on the mysql server itself. I remember something in the way of "sip networking" option or something like this.
View Replies !
Connecting To MySQL On Local (MacOSX)
I am a very new a PHP and MYSQL. I am following the Sitepoint book "Build Your Own Database Driven Website...." Platform: MacOSX: Problem: pg 19. I am installing MySQL: I have typed sudo /usr/local/mysql/bin/mysql/bin/mysqls_safe It comes back with: A mysqld process already exsists. Question: How do I get from there to: mysql>
View Replies !
|
TRACKER
