10-10-2003
I've only just started shelling, and don't really have any experience using perl or PHP. I'm going to try and 'build' my way up to the problem, as the learning curve for a lot of the problems my boss is giving me are quite steep.
I've simply started with:
mysql -h localhost -u unix_username -punix_password
which brings me into:
mysql>
From here I can 'toy around' in mysql, which I haven't done for a while. I think I should be able to replace the 'localhost' with the machine I am trying to connect to and take it from there.
Thanks for the replies, no doubt I'll run into problems over the next few days and be straight back in this forum! Where would I be without it!
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook"
at the command line in mysql heres what i type but i get a error
mysql>create table guestbook
->(
-> name varchar(40) null.
-> url varchar(40) null.
-> comments ... (3 Replies)
Discussion started by: perleo
3 Replies
2. UNIX for Advanced & Expert Users
I need a smal "how to" regarding editing mysql configuration on a unix server. Thanks in advance. (2 Replies)
Discussion started by: Denis.R
2 Replies
3. Programming
(sorry for my english)
Hi, i have an app that uses MYSQL API C.. i trying do a timeout until the table is locked by an other thread , in the docs of Mysql i can see that MYSQL_OPT_READ_TIMEOUT is not implemented for linux ¿?¿?.. any body knows a way to do a timeout until the table is locked by... (0 Replies)
Discussion started by: JEscola
0 Replies
4. Red Hat
Hi All,
URGENT - Please help me form a scipt for this:
I need the LATEST file from a dir on REMOTE machine to be SCP'd to a dir on local machine. (and I need to execute this from local server)
I know that the below cmd is used to find the LATEST file from a dir. But this command is not... (3 Replies)
Discussion started by: me_ub
3 Replies
5. Solaris
I'm manually editing the partition table purely for experimenting. I did
prtvtoc /dev/dsk/c1t0d0s2 > /tmp/prtvtoc
I'm trying to split up partition 5 to make partition 6. I'm running into a cylinder boundary error on partition 6. Any clues?
# vi /tmp/prtvtoc
"/tmp/prtvtoc" 23 lines, 769... (1 Reply)
Discussion started by: adelsin
1 Replies
6. UNIX and Linux Applications
I have set a mysql file to excute everyday morning to generate a html file displayng 2 tables from the database. Sometime they cannot be shown, and it shows the tables are not existed. I have not drop any table, and those 2 tables are not used by any other excution. Anybody know what is happening?... (0 Replies)
Discussion started by: c203040
0 Replies
7. UNIX for Advanced & Expert Users
Hi Am using unix Ksh
Am getting the problem while transferring zero size files through the script .
When i transfer zero size files from local machine to remote machine manually i can able to do it .
My question its beause of zero size files am not able to transfer through script ? or its... (2 Replies)
Discussion started by: Venkatesh1
2 Replies
8. Red Hat
I want to SSH to 192.168.1.15 Server from my machine, my ip was 192.168.1.99
Source Destination was UP, with IP 192.168.1.15.
This is LAN Network there are 30 Machine's Connected to the network and working fine, I'm Playing around the local machine's because I need to apply the same rules in... (2 Replies)
Discussion started by: babinlonston
2 Replies
9. Shell Programming and Scripting
Team,
Presently i am running a script from my local box(i.e jumpbox) to all the remote machines.Basically fetching basic queries like pwd,mkdir,touch etc and i am able to successfully fetch it from my local machine.But when i want to check certain database related queries like the dbstat... (20 Replies)
Discussion started by: whizkidash
20 Replies
LEARN ABOUT OPENSOLARIS
mysql_fix_privilege_tables
mysql(1) MySQL database mysql(1)
NAME
mysql_fix_privilege_tables - Fixes MySQL privilege tables.
SYNOPSIS
mysql_fix_privilege_tables [mysql_root_password]
DESCRIPTION
This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func tables to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions, CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23
If you get 'Access denied' errors, run the script again and give the MySQL root user password as an argument.
SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysqlshow(1),
mysql_zap(1), perror(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
This manpage was written by Christian Hammers <ch@debian.org>.
MySQL is available at http://www.mysql.com/.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 17 March 2003 mysql(1)