Hi,
My internet provider has mysql available but does not provide a user interface. I am using phpmyadmin on a different site but the file size is to large to consider it for the new site.
What choices do I have for working with mysql on a windowsxp setup? My code of choice is php.
Andy
7 2229
You mean aside from using the CLI?
Sorry, I don't know what you are referring to, 'CLI'.
Andy
Sorry, I don't know what you are referring to, 'CLI'.
Andy
CLI stands for 'Command-Line Interface'. On Windows, it would be interfacing with MySQL via the command prompt.
To use it, you would simply open up a new command prompt window (Windows-R, type 'cmd', press return), then type something like this:
"C:\Program Files\Mysql 5.0\bin\mysql" -u username -p
I don't know how to do that.
The mysql db is on the web host server. I have no direct link to it that I can determine, except to upload a php document to connect to the db.
Is CLI practical is this case?
Andy
The mysql db is on the web host server. I have no direct link to it that I can determine, except to upload a php document to connect to the db.
Ah.
To get this working, you'd have to add privileges for a remote User using your server's control panel, then log into MySQL remotely using its -h argument:
mysql -h ip.of.mysql.server -u username -p database_name
This is a fairly difficult setup to troubleshoot, so you might just be better off purchasing more space on your server so that you can install PHPMyAdmin.
Ah.
To get this working, you'd have to add privileges for a remote User using your server's control panel, then log into MySQL remotely using its -h argument:
mysql -h ip.of.mysql.server -u username -p database_name
This is a fairly difficult setup to troubleshoot, so you might just be better off purchasing more space on your server so that you can install PHPMyAdmin.
How do I estimate the additional server space needed for a new install of phpmyadmin?
SQLyog is my interface of choice.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Michael Foord |
last post by:
I'm writing a couple of modules that store information about user
'behaviour'. E.g. a user accesses a certain page of a website at a
certain date-time with a certain referrer.
I need to analyse...
|
by: Stefan Hinz |
last post by:
Degan,
jumping in to try and solve some problems that look pretty obvious to
me ...
> #options for default service (mysqld2)
> (mysqld2)
It should be , not (mysqld2).
|
by: 'nuther Bob |
last post by:
Pardon my heresy...newbie
Is there an MS-Windows front end interface for mySQL ? I'm thinking
of an MS-Access sort of approach for basic database configuration
and maintenance. Maybe there's a...
|
by: Tore Voldbekk |
last post by:
I have set up a bit of MS databases before and enjoy the simplicity of
graphical interfaces. Does it exist something similar for MySQL? I have
tried the MySql control center, but it seems very...
|
by: Craig Taylor |
last post by:
Just curious as to opinions on the best DB interface for mysql ... I
typically use the PEAR DB package but curious as to what others see as
strengths and weaknesses in PDO, native mysql drivers and...
|
by: Chris Seymour |
last post by:
HI All,
Does such a beast exist? Have been looking but haven't seen any. Any
insight would be appreciated.
Thanks.
Chris
|
by: Chuck Anderson |
last post by:
I have decided to create a browser based Php application for a
client/friend of mine (HTML forms to PDF, for one - perhaps a contacts
interface). He has a web site, so I can upload the application...
|
by: JamieHowarth0 |
last post by:
I have been trying to find a solution to this on the Internet for months. Literally, ages and ages and ages, praying that someone in the open-source community has enough knowledge to put together an...
|
by: macca |
last post by:
Hi,
I just started a new web developer job (my first actually) and the
machine they gave me to use is a Mac. Two days in and I'm running a
Win XP environment on my Mac at work (using VMWare), ...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |