09-17-2013
First, install mysql with some demo schema anf data. Once it works, you can move on to the php and web server parts. What web server?
I like SQuirreL JDBC GUI for managing all brands of RDBMS. It is free and your skills are transferrable.
Mysql provides RDBMS access using a TCP/IP port, which you might want to shield. If all SQL clients are on the same server, you should be able to amke it 'localhost-only'. That is the 'service', I expect.
7 More Discussions You Might Find Interesting
1. Linux
Hello,thanks for your help.
I can't connect my MYSQLserver , the note from my Linux System is 'Error 1130 (00000): Host 'my ip address' is not allowed to connect to this MySQL server. What could I do on this?
Thanks again! (4 Replies)
Discussion started by: lancepanda
4 Replies
2. UNIX for Dummies Questions & Answers
Witch OS you will use in a web server(PHP+MySQL)? (0 Replies)
Discussion started by: BSDVirus
0 Replies
3. Shell Programming and Scripting
Hi everyone,
I have an urgent requirement to get some table data from Linux-MYSQL server from HP-UX with oracle database.Is there any way we can get
connected through Shell script from HP-UX and issue select on mysql to get some table data?
Please help me out. (7 Replies)
Discussion started by: kashik786
7 Replies
4. Web Development
Hi, we have some problem with mysql high cpu , would like some help with MySQL Tuning
here are the mysqltuner & tuning-primer details
mysqltuner:
# mysqltuner
>> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
>> Run with '--help' for additional options and output filtering
--------... (1 Reply)
Discussion started by: cataplexy
1 Replies
5. Linux
Hi,
I have installed mysql in linux box as mysql-5.0.77-4.el5_6.6..
I would like to start the server. But there is no mysql file in this location /etc/init.d/
Please advice how to start the server now !!
Thnaks,
Mani (5 Replies)
Discussion started by: Mani_apr08
5 Replies
6. Shell Programming and Scripting
Hi ,
I am trying to install mysql but getting below error
$# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
can anyone provide me this file 'mysql.sock'
Thanks (6 Replies)
Discussion started by: aish11
6 Replies
7. UNIX and Linux Applications
Hello
Please advise me how can I optimize my MySQL server. Or advise which way to look. Maybe someone had similar problems?
Over the past two weeks the MySQL server dropped 2 times. I began searching for ways to optimize the server.
Overall the picture like that:
There is a separate... (2 Replies)
Discussion started by: sergibondarenko
2 Replies
LEARN ABOUT SUNOS
list-jdbc-connection-pools
asadmin-list-jdbc-connection-pools(1AS) User Commands asadmin-list-jdbc-connection-pools(1AS)
NAME
asadmin-list-jdbc-connection-pools, list-jdbc-connection-pools - gets all the JDBC connection pools
SYNOPSIS
list-jdbc-connection-pools --user admin_user [--password admin_password] [--host localhost] [--port 4848][ [--secure|-s] --passwordfile
filename] [--terse=false] [--echo=false] [--interactive]
Gets all the JDBC connection pools. This command is supported in remote mode only.
OPTIONS
--user authorized domain application server administrative username.
--password password to administer the domain application server.
--host machine name where the domain application server is running.
--port port number of the domain application server listening for administration requests.
--secure if true, uses SSL/TLS to communicate with the domain application server.
--passwordfile file containing the domain application server password.
--terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
formatted data for consumption by a script.
--echo setting to true will echo the command line statement on the standard output.
--interactive prompts you for the required options that are not already specified.
Example 1: Using list-jdbc-connection-pools
asadmin> list-jdbc-connection-pools --user admin
--password adminadmin --host fuyako --port 7070 server
XA_connection_pool
Where: XA_connection_pool is the JDBC connection listed.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-create-jdbc-connection-pool(1AS), asadmin-delete-jdbc-connection-pool(1)
J2EE 1.4 SDK March 2004 asadmin-list-jdbc-connection-pools(1AS)