05-05-2009
Take all db dump with username and passowrd
Hi All
I have mysql server,That have many Database with different username and password for each,How can i dump all database collectively,And then restore to an other mysql db sever .
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies
2. UNIX for Dummies Questions & Answers
hello everbody:
I've just faced this weird case, on my sol8 machine i created user called:
mmsctest, and assigned its passwrd to be same as user name "mmsctest".
however when I enter the password follwoed by any charecters like:
mmsctest1,mmsctest123,mmsctest666
Im managed to log in wth that... (2 Replies)
Discussion started by: aladdin
2 Replies
3. AIX
Hey,
i'm using AIX 5.3 which authenticates against a Microsoft Active Directory.
Everything works fine but like everytime there's a problem.
I created users with usernames with more than 8 characters.
Now i tried do login on AIX with these users, which didn't work. The login-window... (3 Replies)
Discussion started by: damn-86
3 Replies
4. Shell Programming and Scripting
I'm trying to use lynx --dump to keep an eye on updates for a website.
The site needs a username and password and I can't find a way to log in using lynx --dump
Any ideas??
Thanks in advance! (12 Replies)
Discussion started by: 64mb
12 Replies
5. Post Here to Contact Site Administrators and Moderators
Is it possible to change my username in this site or is thre a way to delete my account and then create a new one with a diffrent user name (2 Replies)
Discussion started by: floresr
2 Replies
6. Forum Support Area for Unregistered Users & Account Problems
Hi
i have registered but my username is set to default value ( my email). can i change this ? (2 Replies)
Discussion started by: customizeemai
2 Replies
7. Post Here to Contact Site Administrators and Moderators
Moderators,
I want to change my username. I tried but unable to find a way to do that. Can you please assist?
Thanks & Regards
Abedi (1 Reply)
Discussion started by: katherine2008
1 Replies
8. Solaris
Hi all,
System is Solaris10
There is one script which i was able to execute with following entry:-
su user1 -c "/u01/scripts/mfg/_db-start.all"
But when I do this, which asked to do with -i option
su -i user1 -c "/u01/scripts/mfg/_db-start.all"
It gives following message:-... (1 Reply)
Discussion started by: manalisharmabe
1 Replies
9. Solaris
Password got expired but not prompting for new passowrd in soalris 10 and another user got locked why it got locked and when it got locked how to check the logs (1 Reply)
Discussion started by: upender
1 Replies
10. UNIX for Beginners Questions & Answers
Greetings,
The title pretty much says it all. I've snooped everywhere and can't find anything on this. Since our organization went to numeric usernames, using the u|U option for ps returns no processes. Example passwd entry:
320074:DjZAJKXun8HBs:10129:6006:Joe Y:/cadhome/analysis/jy:/bin/bash... (4 Replies)
Discussion started by: crimso
4 Replies
LEARN ABOUT PHP
pdo_mysql-dsn
PDO_MYSQL-DSN(3) 1 PDO_MYSQL-DSN(3)
PDO_MYSQL DSN - Connecting to MySQL databases
The PDO_MYSQL Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is mysql:.
o host - The hostname on which the database server resides.
o port - The port number where the database server is listening.
o dbname - The name of the database.
o unix_socket - The MySQL Unix socket (shouldn't be used with host or port).
o charset - The character set. See the character set concepts documentation for more information. Prior to PHP 5.3.6, this element
was silently ignored. The same behaviour can be partly replicated with the PDO::MYSQL_ATTR_INIT_COMMAND driver option, as the fol-
lowing example shows.
Warning
The method in the below example can only be used with character sets that share the same lower 7 bit representation as
ASCII, such as ISO-8859-1 and UTF-8. Users using character sets that have different representations (such as UTF-16 or Big5)
must use the charset option provided in PHP 5.3.6 and later versions.
Example #1
Setting the connection character set to UTF-8 prior to PHP 5.3.6
<?php
$dsn = 'mysql:host=localhost;dbname=testdb';
$username = 'username';
$password = 'password';
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);
$dbh = new PDO($dsn, $username, $password, $options);
?>
+--------+-----------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-----------------------------------------------+
| 5.3.6 | |
| | |
| | Prior to version 5.3.6, charset was ignored. |
| | |
+--------+-----------------------------------------------+
Example #2
PDO_MYSQL DSN examples
The following example shows a PDO_MYSQL DSN for connecting to MySQL databases:
mysql:host=localhost;dbname=testdb
mysql:host=localhost;port=3307;dbname=testdb
mysql:unix_socket=/tmp/mysql.sock;dbname=testdb
Note
Unix only:
When the host name is set to "localhost", then the connection to the server is made thru a domain socket. If PDO_MYSQL is compiled
against libmysqlclient then the location of the socket file is at libmysqlclient's compiled in location. If PDO_MYSQL is compiled
against mysqlnd a default socket can be set thru the pdo_mysql.default_socket setting.
PHP Documentation Group PDO_MYSQL-DSN(3)