Weird MySQL Message

BitShift

May 16 2006, 08:50 PM

wenever i assign priviledges to a MySQL databases, it seems to work properly but this message is always there

QUOTE

bitshift_wforumu (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:bitshift_wforum:localhost","bitshift_wforumu","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "bitshift_wforumu", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("bitshift_wforum");

My database name is: bitshift_wforum
the username is: bitshift_wforumu

What does all that maen, it displays it anytime i grant priviledges on any mysql server to any user

note: i am new to all this MySQL stuff

Comment/Reply (w/o sign-up)

miCRoSCoPiC^eaRthLinG

May 17 2006, 07:23 AM

Ooh this isn't anything to worry about

Most likely you encounter this when you assign privileges through your cPanel MySQL DB Manager.

As you can see the section is titled Connection Strings - this simply shows you a few common command syntaxes with which you can connect to your freshly created/modified MySQL database.

If you notice carefully - there are two separate connection strings, that are displayed for your convenicne.

One in is PERL, which utilizes the DBI library that provides a uniform wrapper to connect to a wide variety of databases.

The second one is your standard PHP syntax for connection to MySQL...

I believe these are placed simply for your convenience and to give you an indication as to which direction to head for, if you start writing code with these two more popular web-scripting languages.

Comment/Reply (w/o sign-up)

yordan

May 17 2006, 02:20 PM

QUOTE

I believe these are placed simply for your convenience

And I feel these messages very convenient because once upon a time they helped me debugging my php program which had "almost" the correct connection string.

Comment/Reply (w/o sign-up)

BitShift

May 17 2006, 08:11 PM

ahh i see now

thanks for the info

Comment/Reply (w/o sign-up)

BarbedWire

May 22 2006, 04:10 PM

QUOTE(BitShift @ May 16 2006, 09:50 PM)

wenever i assign priviledges to a MySQL databases, it seems to work properly but this message is always there
My database name is: bitshift_wforum
the username is: bitshift_wforumu
What does all that maen, it displays it anytime i grant priviledges on any mysql server to any user

note: i am new to all this MySQL stuff

Hi, maybe just try to name your database into something else, like "forum" and just make another database in that one, you can name it bitshift_wforum if you want to then...
I guess this could help, i never had problems with mysql trying to connect to my database...

Comment/Reply (w/o sign-up)

Similar Topics

Keywords : Weird Mysql Message

Cgiemail / Cgiecho - Sends only blank message (4)
Mysql Connect Error, Too Many Connections. - (1)
Just to begin with I want to say that I am not here necessarily to complain about it lol. I'm
not sure but if my site is possibly helping to contribute to the problem, I'd like to know if
anyone knows any good articles or tutorials that might have information on what to look out for that
could contribute to these sort of problems. I know my site may not have anything to do with it (as
I don't think it is overly popular or anything or even close), but knowing what to look out for
when messing with PHP/mySQL would be great. I personally haven't found too...

Connecting To Astahost's Mysql - (8)

Now this topic could fit under lots of subforums but this isn't really a programming question
but rather asking what asthosts mysql host is? Long story short I need to connect to a mysql
database via c++ (I dont even know if that is possible) but I cant use localhost (for obviouse
reasons). Could you tell me how to find the mysql host for my account? Thanks, Sparkx...

Mysql Server Not Stable After Hard Disk Swap On April 6th - (2)

Hi... All are aware of the server issues happened on April 6th:
http://www.astahost.com/current-server-iss...ade-t15435.html I'm still facing the issue with
the MySQL Server after the server problems!! I'm using phpBB forum for my site, and it often
shows some error message after losing connection with the Database server! Its happening many times
in a minute! Its not at all stable after the server issues! I had tried repairing the databases and
optimizing the databases! But nothing helped me! Still facing the issues! Its showing like:
DEBUG MODE ...

Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql - (3)

Hi all, Please help me! My site was working fine! ( www.fun.niranvv.com ) But now, its showing
one error message as: Warning: mysql_connect() : Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2) in
/home/niranvv/public_html/fun/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is
not a valid MySQL-Link resource in /home/niranvv/public_html/fun/db/mysql4.php on line 330 Warning:
mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/niranvv/public_html/fun/db/mysql4.php on line...

What Is The MySQL Version @ Asta ? - MySQL 4.0.26-Max
(16)

Hi, A few question here, 1. Just wondering, the MySQL hosted on astahost.com is actually version
"4.0.26-Max" according to phpmyadmin. But why is cPanel showing "4.1.21-standard"? 2. Actually
i've existing codes that need function introduced after version 4.1.1, is there by any chance
astahost or xisto is going to upgrade the MySQL package? Thanks...

Problem With MySQL - (5)

I tried to visit my website today and I recieved the dreadful page from my php-nuke site "There
seems to be a problem with the MySQL database" First I thought, "no big deal server is probably
rebooting or down for a little bit" So i logged into my cpanel and clicked on "Server Status".
Thats when I started worrying. It said the MySQL servers were up and runnign fine. I went back to my
main page and looked at my MySQL server count and instead of saying 2/99 it now says NA/99 I am
unable to create a new database and I recieve this error when I click on PHPmyadmin QUO...

Problems With cPanel - Showing some error message (9)

Hi all, I was trying to upload some files to my account using cpanel! There was no problem in the
beginning! But suddently it shows one error message as: Sorry for the inconvenience!
The filesystem mounted at / on this server is running out of disk space. cPanel operation has been
temporarily suspended to prevent something bad from happening. Please ask your system admin to
remove any files not in use on that partition. (Edit: Authentication is working fine! After
authentication only, ith shows the error message like this! ) Please check this one: htt...

Php And Mysql Version. - (7)

Is there any plan to upgrade or see if it can be upgraded to PHP5 and mySQL5 in the future?...

Mysql Error Never Seen On My Site Before (too Many Connections). - (13)

I just tried to visit my site to see if anything had changed on my forums and such and I got this
message: Warning: mysql_connect(): Too many connections in /xxxx/xxxxx/xxxxxx_xxxxx/xxx/xx_xxxx.php
on line 7 Error! Could not connect: Too many connections. I have never recieved this error before,
does this mean someone is mucking with my site somehow??? The particular php file it mentions is
the one that defines variables like db username etc and connection to the site's database that I
include wherever it is needed in various file for the site. EDIT: I managed t...

Help Me! - Frontpage & phpBB with MySQL (3)

I was just approved an Astahost account with the starter package. I explored the Cpanel a bit
and have got the following problems : 1.Frontpage Extensions The Cpanel states that the
Frontpage Extensions have been installed. But when I uploaded my site on frontpage at
"ftp://ftp.mysitename.astahost.com/public_html/" it stated an error that Fronpage Extensions are not
installed on this server! When I opened my site online, I can see the page, but I cannot see any
graphics/images! Also, my forms and other stuff isn't working either. Please help me out and let
me...

Problem With MySQL Not Being Able To Connect - Anyone know the reason for this error... (9)

Hello everyone, Im currently having a problem with mySQL, I wrote a PHP login script that
doesnt seem to be working for some reason. I created a database and everything looks correct, is
this a server issue or is the issue related to my script? But anyway this is my error, hope someone
can help Ive tried to search forum for answer but none of the posts seems to answer my question:
QUOTE Warning: mysql_connect(): Host 'gamma.xisto.com' is not allowed to connect to this
MySQL server in /home/hp2001/public_html/ucscKGD/checklogin.php on line 10 cannot co...

MySQL - Can't Connect - Cristal Report (1)

From http://thoaionline.com (hosted by Astahost) QUOTE Warning: mysql_connect(): Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
/home/pheart/public_html/thoaionline/includes/database.mysql.inc on line 31 Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) In cPanel Mysql
databases 0 / 99 But I have 5 MySQL databases in my account (maybe more). All of them become
unusable now. Some more messages from http://website.thoaionline.com QUOTE Warning:
mysql_pc...

Can I Access MySQL Database From Outsite, Directly - (10)

I'm going to make an OFFLINE FORUM. So I want to know is that possible or not. My paid host
don't allow that. How about astahost?...

MySQL Database - Important Report (3)

I'm writing this to report about a error. One of my mySQL database has been droped and my site
stop working. I don't know the reason. I'm hosted on gamma server. I think you (admin)
should check it. PS: One of my paid hosting provider also met this problem a few day ago....

IPS Driver Error / MySQL Database - What in the world? How is this possible? (1)

Just several hours ago, I couldn't access my website/forum because of some error with an SQL
socket or something like that. I need desperate help because I don't want to reformat everything
again. Well, here is what comes up: IPB WARNING mysql_connect(): Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (Line: 114 of
/ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can
try to refresh the page by clicking here. Error Returned: SQL error: Can't connect to local
M...

General Problems With New Account - MySQL problems and quota issues (2)

I just got a new account and CPanel reports that I have -380.2 MB of quota space and using 400.2MB.
This disables some of Cpanel's functions. It would have been nice to use the automated Mambo
installer, but no biggy. I uploaded the latest Mambo .tar.gz from my FTP program and unpacked it
via Cpanel's file manager with no problem. When I first logged into the system I created a new
Database for mambo and a new user for that database and linked the two from Cpanel. I logged off to
watch something on TV and came back and that database isn't being reported...

Problem With Mysql - Cannot connect to database.... (6)

Hi, this is the first time after I got my hosting to try and use MySQL. My site is
http://abhiram.astahost.com . I created a user in CPanel -> 'MySQL Databases' as root. So,
the new user created will be 'abhiram_root'. Similarly I created a database called
'webpage' (which changes to 'abhiram_webpage'). I set up the database and the tables
using phpMyAdmin and uploaded the files after making changes to the user name and the database. But
it's not opening the database. It's connecting to MySQL without any problems, but it
isn'...

Mysql Error - (5)

Hey i got this error trying to install something on my database CODE mysql error: 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 'rpg_class` (`name`, `folder`, `regatt`, `magicatt`, `magicdef` mysql
error number: 1064 can anyone tell me what this means or how i fix it?? thanks in advance...

MySQL Errors? - Error 13! - (0)

Recently been attacked by "Can't create/write to file '/tmp/#sql_28e2_0.MYI' (Errcode:
13)"? Then its a simple fix, please DELETE (backup first) your SOURCE files that talk to the MySQL
database, and re-upload them This will purge them from the system and force them to recreate the
temporary files. Do NOT delete your database, just backup your files, delete them, re-upload them
and youll be fine. This is due to MySQL crash. Easily fixed and no data has been lost. Sorry guys
Details: MySQL crashed while writing data, it seems the temporary file has bee...

Looking for weird, mysql, message