04-27-2009
Strange Mysql issue
Hi all,
I recently changed the name of my hostname from 'abc123' to 'abc456' (as an example).
I then added a user in my mysql database with the new host and removed references to the old users and hostname.
The strange thing is though, a process using the database still uses the old hostname!!
which then forced me to add the old names back into the database....
can anyone explain to me why this is the case and how i can ensure that all processes use the
new hostname i.e. 'myuser'@'abc456' and NOT 'myuser'@'abc123'
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I am comparing two numbers, but it gives strange results:
My Code:
if
then
echo "True"
else
echo "False"
fi
This code gives False for the follwoing comparison
where as True for the following:
Any reason for this? Both Should have given False...
I am using... (9 Replies)
Discussion started by: shihabvk
9 Replies
2. Cybersecurity
hi there , :cool:
um facing a problem with my root passwd
i want to set my root password and when i do i get the following ::
#
# passwd
passwd: Changing password for root
New Password:
Re-enter new Password:
passwd(SYSTEM): They don't match.
Please try again
New Password:... (6 Replies)
Discussion started by: badrali
6 Replies
3. UNIX for Dummies Questions & Answers
I have created a server monitor program in Java that connects to servers via SSH and constantly refreshes the new server load every 3 mins. The problem is that even though it is a Java app running shell commands to get the load info, the commands still appear in 'history'.
The question is.. is... (1 Reply)
Discussion started by: AndrewSH
1 Replies
4. UNIX for Advanced & Expert Users
hi again
i'm running a centos 4.x box with sendmail and openwebmail. I had a weird situation where users couldn't not get authenticated using a pop mail client but but were able to aunthenticate using the openwebmail webmail client. I looked through the logs and didn't see anything strange. I... (0 Replies)
Discussion started by: mcraul
0 Replies
5. Solaris
Hi ,
running solaris 10 on t5120 and i see ILOM and ALOM (SC) interfaces working fine earlier and suddenly they are responding strangely,
First thing , I can connect fine to ILOM or ALOM but then console -f just hangs..
resetsc error :
I do not really want to poweroff and poweron... (13 Replies)
Discussion started by: upengan78
13 Replies
6. AIX
hi all
we upgraded hacmp(powerha) from 5.2 to 5.4 recently .
during the failover testing, we found a strange network issue. after standby node took service ip address (172.15.100.8) online at standby NIC, we were able to log in the standby node by telnet 172.15.100.8 which stays at... (1 Reply)
Discussion started by: rs6000er
1 Replies
7. UNIX for Dummies Questions & Answers
Hello All,
PC: CuBox-i (*i.MX6) Mini-PC
OS: openSUSE 13.1 (Bottle) (armv7hl)
Kernel: 3.14.14-cubox-i
# uname -a
Linux CuBox-HQ 3.14.14-cubox-i #1 SMP Sat Sep 13 03:48:24 UTC 2014 armv7l armv7l armv7l GNU/LinuxSo I've been having this random issue happen on this PC where a few strange... (12 Replies)
Discussion started by: mrm5102
12 Replies
8. Shell Programming and Scripting
more works.sh
#!/bin/ksh
{
print "From: reportgenerator@myserver.com"
print "To: randomguy@myfirm.com"
print "MIME-Version: 1.0"
print "Content-Type: text/html"
print "Subject: Disk Report"
print "<body>"
print "<table border=1>"
... (3 Replies)
Discussion started by: mohtashims
3 Replies
9. Shell Programming and Scripting
Starting sendmail throws this error:
I decided to see the permission on the files under /etc/mail and this is the output:
# ls -ltr
total 284
-rwxr-xr-x. 1 root root 1847 Jan 27 2014 virtusertable
-rwxr-xr-x. 1 root root 127 Jan 27 2014 trusted-users
-rwxr-xr-x. 1 root root 92... (3 Replies)
Discussion started by: mohtashims
3 Replies
10. AIX
I just intalled java8_64.jre and .sdk respectively
installp -agXYd . Java8_64.jre Java8_64.sdk 2>&1 | tee installp.log
Worked like a champ. Now I see this--
jeff@server:/usr> ls -l | grep java
drwxr-xr-x 9 bin bin 512 Sep 22 2010 java14
drwxr-xr-x 7 bin bin ... (9 Replies)
Discussion started by: jeffs42885
9 Replies
MYSQL(1) General Commands Manual MYSQL(1)
NAME
mysql - text-based client for mysqld, a SQL-based relational database daemon
SYNOPSIS
mysql [-B|--batch] [-#|--debug= logfile] [-T|--debug-info] [-e|--exec= command] [-f|--force] [-?|--help] [-h|--host= hostname]
[-n|--unbuffered] [-p[pwd]] [--password=[pwd]] [-P|--port= pnum] [-q|--quick] [-r|--raw] [-s|--silent] [-S|--socket= snum] [-u|--user=
uname] [-v|--verbose] [-V|--version] [-w|--wait]
DESCRIPTION
The mysql program provides a curses-based interface to the SQL-based database server daemon, mysqld(1). Full fuller documentation, refer
to the HTML documents installed with the package.
OPTIONS
-B|--batch
Print results with a tab as separator, each row on a new line.
-#|--debug=logfile
Employ the specified debug log.
-T|--debug-info
Print debug information upon exiting.
-e | --exec=command
Execute the specified command and quit (--batch is implicit).
-f|--force
Continue even if the face of a SQL error.
-?|--help
Display a help message and exit.
-h|--host=hostname
Connect to the specified host.
-n|--unbuffered
Flush the buffer after each query.
-p|--password[=pwd]
Employ the specified password when connecting to the database server. If a password is not supplied, it will be requested interac-
tively.
-P|--port=pnum
Employ the specified port number for connecting to the database server.
-q|--quick
Do not cache the result; print it row by row. This may slow down the server if the output is suspended.
-r|--raw
Write fields without conversion. (used with --batch).
-s|--silent
Silent mode: reduce the amount of output.
-S|--socket=snum
Employ the specified socket file for connecting to the database server.
-u|--user=uname
Employ the specified user name for logging in to the server.
-v|--verbose
Verbose mode: write more Specifying this option twice produces a tabular output format.
-V|--version
Print the mysql version number and exit.
-w|--wait
Wait and retry if the database server connection is down.
FILES
/depot/bin/mysql executable
/depot/bin/mysqld executable
/depot/bin/safe_mysqld
executable shell script for starting mysqld safely
/site/var/mysql/data location of database files
EXAMPLE
You can also read a backup dump file back into MySQL with:
mysql database < backup-file.sql
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 6.3, distribution 3.20.20 Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no
warranty. Manual page by R. P. C. Rodgers, Lister Hill National Center for Biomedical Communication, U.S. National Library of Medicine
(rodgers@nlm.nih.gov).
13 June 1997 MYSQL(1)