I am using mysql version Server version: 5.0.77 and php version PHP 5.1.6 (cli) (built: Nov 29 2010 16:47:37)
My code is below:
<?php
$username="root";
$password="";
$hostname="localhost";
$dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
$selected = mysql_select_db("examples",$dbhandle)
or die("Could not se
Hi all, I have a basic question on MySQL:
http://de.php.net/manual/en/ref.pdo-mysql.php
"Use --with-pdo-mysql[=DIR] to install the PDO MySQL extension, where the optional [=DIR] is the MySQL base install directory."
Which file should be used for that command?
edit: think it's mysql, but I'm getting "Access denied for user 'root'@'localhost' (using password: YES)".
I receive the following error when trying to connect to mySql through phpmyadin:
MySQL said:
1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.
Hello, I want to install piwik and have some questions about Slackware PHP,MYSQL options.
I'd configure my Apache, PHP, Mysql from
how-to-run-apache-php-mysql-on-startup-and-install-phpmyadmin-slackware-12-2, but have Slackware 13.1
PDO and MYSQLI are already in my php.ini.
Code:
extension=bcmath.so
extension=bz2.so
extension=calendar.so
extension=ctype.so
extension=curl.so
extension=dba.so
e
I am trying to crate a shell script that would:
connect to a remote server that has MYSQL running
On success run "CREATE DATABASE foo;"
So far I tried:
#!/bin/bash
mysql -h 111.11.11.11 -u root -p'XXXXXXX'
mysql> CREATE DATABASE foo;
or
echo "CREATE DATABASE foo;";
But no success.
I am using the command line to run the shell script.
# sh create_mysql_database.sh
but all it does is
I have the following problem:
I cant get etherpad running, when my firewall rules are active.
My firewall: http://pastebin.com/82APzKhi
telnet localhost 3306 gives connection timeout
ps aux | grep mysql:
root 15212 0.0 0.0 4112 712 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 15526 0.7 0.9 426056 75392 ?
Hi,
I have install MySQL serve in Fedora 16 32 bi distro that I have on my pc, but I can't start MySQL from command line. Can you please help?
in Mysql-Workbench,i clicked on open connection to start querying and i get a dialog where i get the hostname,username,password,etc...
in hostname it has 127.0.0.1, user set as root, and i've enter the root password for mysql and i get this:
Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
Lost connection to MySQL serve
Hey guys, so I've been running F17 for quite some time now, and earlier I attempted to install mysql for computer science class, and so far I have been the recipient of two not so unfamiliar errors I've gotten in the past while trying to install apache and other server software, number1 is it didn't prompt me to configure my mysql root password and secondly, every time I try to start it up I get t