"Connect By" / Connect By Prior Clause
One thing that very annoying me in SQL SERVER is the lack of the "connect by" support. The other thing is that in order to take advantage of multi-processors/cores system, you have to pay a good deal of money.
Therefore, I'm examining MySQL now & wanted to know if there is a "Connect by" support in MySQL? It's not just syntax issue, but also performance issue. Anyhow, it's far more comfortable.
View Complete Forum Thread with Replies
Related Forum Messages:
Couldn't Connect To /var/lib/mysql/mysql.sock: Connect: Permission Denied
I try to connect from a perl program to mysql and get: >> Couldn't connect to /var/lib/mysql/mysql.sock: connect: Permission denied 1.) The /var/lib/mysql/mysql.sock file EXIST! 2.) The mysql server is UP, I can connect from the terminal using "mysql" command (which in fact uses this socket!). 3.) /var/lib/mysql/ and everything in it has user=mysql and group=mysql 4.) mysql.sock has 777 permission So I am compleatly helpless why perl can not connect!!! The perl program is OK, I have transfered it to an other server and there it works. The error must be somewhere at mysql but I cant find it
View Replies !
Cant Connect
Ive been digging far and wide and im using the old password option, like its mentioned here http://forums.mysql.com/read.php?38,2511,5323 Ive also downloaded and installed the mysqli extension http://dev.mysql.com/downloads/connector/php/ But I still get the same error. What could I be missing ?
View Replies !
Connect From
how to connect from home host to my hosted msql from phpnuke config its sayes localhost how do i get the real ip of the host idont want the localhost
View Replies !
How To Connect
i using NetBeans 5.0 to connect to MySQL 5.0 database. the connection can work in the server computer but cannot work if i use different computer to connect. how to i set for remote connection.?
View Replies !
See Once ! & Help Me , Can Connect ! After I Can't Do ....... ?
the older thread goeing on, so i started new one, Now i can get a connection, but i can't do anything with this connection whenever i attempt to select a database or tables, it saying permission denied, see my code once Plz $con=@mysql_pconnect("localhost","root","abcd"); if (!$con) echo "<br>Unable to connect",mysql_error(); else echo "<br>connected",mysql_error(); $dbcon=@mysql_select_db("project",$con); if ($dbcon) echo "<Br>Database Selected"; else echo "<br>Database not selected",mysql_error(); I got this as a result connected Database not selectedAccess denied for user: 'root@localhost' to database 'project' the same thing happens in console also
View Replies !
CONNECT Or USE ?
We have a shell script where the mysql query occasionally hangs. I notice that the query uses CONNECT instead of the more usual USE. Can't actually find any info on the CONNECT command but it seems to work. e.g. TITLE=`mysql -u$DBUSER -p$DBPWD -h$DBSERVER -N -e "connect orinfo;select title from task where taskid='${TASKID}';"` what to use, CONNECT or USE in this case? Also, the taskid column is an integer. Could where taskid='${TASKID}' be confusing mysql because I have single quotes indicating a string?
View Replies !
How To Connect To A SQL DB?
I have a MySql Database with some information which I would like to display on a screen! It sounds quite simple, but seems to be a big issue for me! I stored the following script in a index.php file and open it in my browser over http://localhost/index.php. However I only get an empty page back without any error msg. If I delete everything apart from <?php print("Hello"); ?> It works fine PS: If I open the DB directly with Webmin the path is https://localhost.localdomain:10000/mysql/ and not local host? Does this make any difference? Code:
View Replies !
Can Connect To My Db
just installed php 4, mysql server 4.1 and apache 2.0 on my winxp machine. i can connect to my db and create tables using mysql administrator program with the root login, but i can't connect to my db using php for some wierd reason... Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Program FilesApache GroupApache2htdocsswordsOfTwilightinsert.php on line 13 Unable to select database <? $user="root"; $password="----------"; $database="swordsoftwilight"; mysql_connect(localhost,$user,$password); @mysql_select_db($database) or die( "Unable to select database"); $query=$query = "INSERT INTO members VALUES ('','Sinstone','--------','Paul Georges','20','Quebec, Canada','sinstone@gmail.com','')"; mysql_query($query); mysql_close(); ?>
View Replies !
Connect Across LAN
GRANT SELECT, UPDATE, (etc etc) TO `root`.`192.168.0.%`; However, when I try to establish the ODBC connection, I'm getting: [MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'HE-NOTEBOOK' (using password: YES) should set up the ODBC so that it 'sees' my laptop's IP address (192.168.0.6) instead of it's 'name' (HE-NOTEBOOK)?
View Replies !
Connect To DB
I would like to connect to my database using the command line prompt. My database is on a remote server. This is part of a hosting package that I have purchased for my website. I currently use phpMyAdmin to access my database. However I would like to use the command line. I found this page on this site: http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.html However I still have no idea how to connect to my database. I don't know where to start. Do I just bring up the command prompt? Do I have to start in a specific directory?I am running Win XP Pro
View Replies !
Can't Connect
I'm very new at this,to my understandig mysql supposed to be a built in db ,when i'm trying to connect i'm getting " error 1044: Access denied for user :@lolocalhost to database 'mysql' when i'm trying to open DB the database i'm suuposed to be working on iget the same error. I didn't created it. It saved in mysql/data. I can query it from "mysqlmanager" but can't connect from the command line!! The target is to connect to it from PHP file but I get no response there.
View Replies !
Can't Connect From PHP
I installed mysql 5 on a MS-XP machine running apache 1.3 and php 4. When a php script attempts to connect to mysql using mysql_connect($host, $user, $pass) the following error appears: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL ... When I use the same hostname, username and password via the commandline or from a GUI frontend, the connection works.
View Replies !
Cannot Connect
I am trying to install Textpattern - after correct upload, I have entered the correct MySQL username, password, and database. It's linked to the right path - I click next during installation and get the following: Checking database connection… Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in D:hshomesimplymysimplymysims.com extpatternsetupindex.php on line 195 Can’t connect to database.
View Replies !
Connect From Www.1.com To Www.2.com
PHP <? /*--------- DATABASE CONNECTION INFO---------*/ $hostname="www.1.com"; $mysql_login="myusername"; $mysql_password="mypassword"; $database="mydatabase"; // connect to the database server if (!($db = mysql_pconnect($hostname, $mysql_login , $mysql_password))){ die("Can't connect to database server."); }else{ // select a database if (!(mysql_select_db("$database",$db))){ die("Can't connect to database."); } } ?>
View Replies !
Remote Connect
I've installed MySQL 4.1.12 on my server, I can connect from the local machine with navicat, but not from a remote machine. I checked with 'nedstat' and there is something listening on port 3306. I have tried several users and settings. What i want is to set a user name (:support) and that this user can connect remotely with navicat to the mysql server. How would I do this? Or what am I doing wrong?
View Replies !
Can't Connect Port = 0??
I have root access to this server which has been preconfigured. I can connect using the mysql command tool. But I cannot connect using any mysql GUI software (I am currently tunneling the 3306 port to 3306 on the server using SSH). So i ran mysqladmin variables. And got the following: port 0 instead of the usually port 3306. Obviously I cannot connect on port 0. How can I troubleshoot this and get mysql running so I can connect via tunneling?
View Replies !
Can Not Connect Mysql From Php
I install Fedora 4 with web server, after that I installed mysql 5.0.15. Now I can connect to mysql from command line and mysql-administrator and mysql-query-browser. But when I try to test to connect from php code, it told me that "can not connect to local mysql through /tmp/mysql.sock. /tmp/mysql.sock is my sock file to connect and permission is set good. when I add phpinfo() to my php code, it show me that mysql lib php uses is 4.1.X, and sockect file is /var/lib/mysql.sock. It looks like PHP mysql module still be old version, and can not connect to the new 5.0.15. Anybody can give a hint on that?
View Replies !
Connect MySQL To SQL
I use DTS (Data Transformation Services) to transfer data between two SQL servers. I want to import data into MySQL from SQL. Does MySQL have anything close to DTS? What would it be called?
View Replies !
Cannot Connect To MySQL Using VB.NET 1.1
I am using VB.NET 1.1 and cannot connect to a MySQL (v5) database. I've done the following: 1) Create a DSN for MyODBC. 2) Connect using: Driver=MySQL ODBC 3.51 Driver; Server=localhost; Data Source=test; UID=test; PWD=pwd; OPTION=3 When I run my app, I get this error: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'. I tried changing the connection string to Provider=MySQL ODBC 3.51 Driver; Server=localhost; Data Source=test; UID=test; PWD=pwd; OPTION=3 (Instead of Driver, I change it to Provider - most of the examples I found on the net including those from MySQL AB uses Driver). Now I get this error: The 'MySQL ODBC 3.51 Driver' provider is not registered on the local machine.
View Replies !
Connect Command
I'm new to MySql and I'm having a problem figuring out how to configure my Connect command so I can test on my PC and upload scripts to my ISP without constantly changing the Connect command to reflect the applicable host. I use LocalHost on my machine and then change it to my ISP's IP on their network before uploading the scripts. I'm sure there's something I'm missing in the manual about setting up Grants.
View Replies !
No Connect - Error 111
I have MySQL 4 running on a Win2K3 Server. I can connect to it from MySQL Control Center running on a client PC on our network. But I cannot connect to it from the outside world. Get the "can't connect (111)" error. The permissions table has a user "user@%" in there and this user has global access to everything. If I Telnet to the MySQL port from the outside world I do get a connection and the MySQL version echoed back to me so the port appears to be open (not a firewall issue). But trying to connect with the following command will not work: mysql -h server.name.com -p 8123 -u user It prompts for password - then gives the "can't connect (111)" error. Neither can I connect to it from the outside world through code in PHP (same error returned) This error number seems to be a catch all - meaning "can't connect"....period Is there some way I can get more meaningful information as to WHY it can't connect? Bad password?? Bad user name?? No permissions??
View Replies !
Can't Connect From Localhost
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem. However, when I try to connect(mysql -u root) from localhost, then I get access denied. Checked the user table and root can connect from anywhere(%). I am running 4.1.1 alpha on Red Hat with the --old-password option.
View Replies !
Connect To A Remote DB
Is it possable to to have a program on my server that can access his db? <?php MYSQL_CONNECT("http://remotehost.com","db_name","pass_word") OR DIE("Keine Verbindung zur Datenbank"); mysql_select_db("db") or die("Didn't work again");
View Replies !
Can't Connect Over Network
I have mysql 4.0.16 on my windows machine and have just installed suse linux on another machine. It comes with mysql 4.0.15. After I got the user setup I was able to use the mysql client on the windows machine to connect to mysql on the linux machine I even used mysqldump piped to mysql to dump a database to the new server. But now I can't seem to login anymore. I don't think I changed any settings on the linux machine so I am at a loss as to why I am getting this error. ERROR 2013: Lost connection to MySQL server during query That happens immediately after I type in mysql -h 192.168.1.2 -u cdw -pxxxxxx and hit enter.
View Replies !
PHP/mySQL Connect
In a PHP book from 2001 it states that C:mysqlin> --standalone will work to get the process running in the background, yet it doesnt recognize the standalone command. Was this omitted in 4.x?
View Replies !
Dbi Connect Failed
I got error like this: DBI connect('database=ocid;host=localhost','ociddb-admin',...) failed: Client do es not support authentication protocol requested by server; consider upgrading MySQL client at util/initfpdef.pl line 52.
View Replies !
Client To Connect To A 4.1 Db
I'm trying to migrate my website to a new server and I wanted to point the old servers at the new database. The old servers have a 3.23 client and db and the new server is running the latest stable of mysql.
View Replies !
Can't Connect To Localhost
I've been using MySQL for 2 weeks and it's ok... till this morning, when I connected to my database and got an error like this "Can't connect to localhost (10061)". In Task Manager, I couldn't find the mysqld.exe process as usual, so I tried to run mysqld (--install, --console... etc. I'm just a MySQL newbie *_*) and mysqladmin... but it was useless. I'm helpless right now.
View Replies !
Connect Php-file
I have a guestbook on a webserver that doesnt have MySQL and i need to connect the guestbook to my other webserver that has MySQL, is this possible? usually you write localhost but of course that doesnt work and i have tested with the URL to the database but with no luck.
View Replies !
Connect To An External Db
Ive got 2 free hosting accounts at different hosts. Im trying to connect my site on one host with the mysql db on the other host. Is that even possible? I've used this file to connect to the db. PHP Code: $hostname='mysql'; $user='bhalos'; //'user name for MySQL database'; $pass='***; //'Password for database'; $dbase='bhalos'; //'database name'; @$connection = mysql_connect("$hostname" , "$user" , "$pass") or die ("Can't connect to MySQL"); @$db = mysql_select_db($dbase , $connection) or die ("Can't select database."); ?> When using this on the other site it says: cant connect to mysql. What do i need to change?
View Replies !
Not Connect To MySql
I tried running a php/mysql script and this message appeared: Could not connect to MySql because:. Can someone please help me solve this problem.
View Replies !
Connect My Site
Im trying to connect my webpages to the MySql database that i have as part of my hosting account, ive dropped a MySqldump file into the database and have been trying to connect my site to the database but im somewhat confused about how to do this, i understand ive got to use a little bit of code to make the connection but where do i place that code? and do i place it on every webpage, im trying to put together GET variables so that when someone clicks the "Buy" link it should then make the billing popup appear, but mainly at the moment my main confusion is about actually what to insert and where, in order to make the connection between my pages and the database
View Replies !
Fail To Connect
I have a problem where one of my mysql servers fails to connect for no apparent reason - I find that if I re-enter a 'grant' statement for the connecting user and host and then flush privileges, that everything works again. Has anybody come across this before and know what to do about it? my my.cnf looks like this:Code: [mysqld] datadir=/export/data log=/var/log/mysql-messages set-variable = max_connections=100
View Replies !
Unable To Connect
I updated mysql on my computer(OS windows) and when I run any script i get: unable to connect to mysql server: Client does not support authentication protocol requested by server; consider upgrading MySQL client I'm a windows user so can someone advise me as to what to do to fix?do i have to download client tools separately?
View Replies !
Vb6 Connect To Mysql 4.
i have a large store with wifi access via several netgear access points in repeating mode.Also several computers with winxp myodbc 3.51 and a vb6 app which access a db via the wifi connection when needed. My problem is that sometimes when diesel forklifts go past the pcs, or access points the wifi connection is broken for a few seconds which results in the vb6 app crashing out when it trys to get more data from mysql. I have found the only way to get the vb app to work then is to run the mysql login bit again. Is there a default timeout for a connection somewhere in odbc or mysql which I could increase to solve this.??
View Replies !
Connect To The MYSQL
I am familiar to SQL Server. I was wondering how we can connect to the MYSQL which is under same domain from our system. I do know that we can do that pretty easily in SQL Server by registering the server.
View Replies !
Best Way To Connect Three Tables?
I have two content tables and a key table tying them together. I need a third content table with a many-many relationship to the other two. Should I do two more key tables with three columns, or just one with four columns? I have a content management system, using a two-table database which I will simplify here. I have to use ISAM tables. I. Articles: art_id (PK, autoincrement), Content (TEXT) 1 French fries raise cholesterol by . . 2 How to get enough fiber . . . 3 If you want to get started walking . . II. Categories: cat_id (PK, three letters), category nut nutrition exe exercise sta getting started med medical I also have a third table that ties them together, I don't know the term for it: III art-cat-id: PK (autoincrement) art_id cat_id 1 1 nut 2 1 med 3 2 nut 4 3 exe 5 3 sta So far, it's working great. I drive php $-GET navigation with the key numbers which determine page style, graphics, and of course content. Now,(to make improvements in page navigation) I need to add a third table with a subcategory or title, such as "Healthy Eating" or "Walking". There will be about 75-100 of these compared to 16 categories and they will have a many-many relationship with both the category table and the article table. My Question(s): Should I do 1. one key table with three columns: PK, newtable_id, art_id, OR 2. one key table with four columns: PK, newtable_id, art_id, cat_id, OR 3. two more key tables? or 4. Is there a completey different way to do it?
View Replies !
Connect To Mysql On IIS
i have just installed mysql on my windows 2003 server and nwo i have a question, 1: after installing it. how do i connect to it to make tables etc? 2: i use IIS 6 and i have my webroot folder on q:/webroot and wonder if i can set the mysql database to be in q:/webroot/database and how i would do that.
View Replies !
Connect Via Root
I have just installed mysql 5 and accidentally set it to not allow root logon from remote machines. Whats the easiest way of fixing this? I need to logon via my own machine
View Replies !
Not Able To Connect To Server
I can only connect to server on the local machine, not from a client. I can connect with same user on the server machine. Only thing that looks weird is ODBC is putting the machine name on the user id and I don't know why. I'm using the ODBC admin's test connection button. I get message "Access denied from user admin@<machinename>". Is it supposed to do that?
View Replies !
Can't Connect Via PHP - Mysql_connect()
I have installed PHP 5.1.1 , Apache 2.2.4 and mysql-5.0.41 on win XP Pro. Mysql commands are working properly on Mysql CUI and not able to connect with PHP. I always gets "Call to undefined function mysql_connect()" It seems to be a common problem!!! Why??? Both PHP and MySQL has the file. I have tried copying php_mysql.dll, php_mysqli.dll and also libmysql.dll into my c:php and i have edited php.ini file also but with no luck! I still cannot get rid of this error on the Browser "Fatal error: Call to undefined function mysql_connect() in <file.php> on line xx" is the msg displayed... (xx is the first row below) $dbLink = mysqli_connect("localhost","root","mypassword"); print mysqli_get_server_info($dbLink); mysqli_close($dbLink); Code:
View Replies !
Could Not Connect To The Specified Occurnce
I get error number 1130 when trying to connect to any of my databases It says my hostname is not allowed to connect.,.. Strange thing is i can connect no problem through any of my browsers!! It also pings fine at an average of 43 login details are correct as well!
View Replies !
Can't Connect To Database V 5.0
I have installed the 5.0 version. I can access the Server Instance Configuration but need to access MySQL Administrator to set up access to my database at home for a remote connection. However, I have no idea how to gain access into Administrator. I have read the tutorial but can't gain access into Administrator. I know my local machine ip address and have used this as the host name but am not clear on the rest. Do I need to be using the same user/pass from the Instance Configuration to log into Administrator? If so, this isn't working.
View Replies !
Cant Connect To The Server
i tried to run the query browser and it keeps giving me this error MySQL Error Number 1130 Host '192.168.0.105' is not allowed to connect to this MySQL server if you want to check the network connection, please click the ping button. i filled the name of my computer and the username and password (the ones i use to log into my computer) and the port is fine too...i really dont know what it can be..y tried reinstalling the whole thing..but still the same problem
View Replies !
Can't Connect To Server
I am trying to connect to my server but keep getting a "cannot connect to server" error. When I ping it it says, "request timed out." I've allowed port 3306 in both windows firewall and in my linksys wireless router. I've even tried to disable the firewall.
View Replies !
Connect To MySql DB
I have an application built for science students to design lab reports and the teacher and student information is all stored in a mysql database. Some schools have no trouble connecting, but others are behind a firewall and their schools won't open a port in their firewall. Is there anyway they can connect to, get data from, and send data to my DB without using an open port in a firewall?
View Replies !
|
TRACKER
