473,322 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

remote creation of MySQL db

Ike
I am trying to establish a database on a MySQL database, wherere the MySQL
version is 5.x. Therefore, MySQL uses the new hashing algorithm with regards
to it's passwords.

The database is behind a firewall where I am given a hole through port 3306
to the IP where I am running php.

However, because of the password hashing algorithm in MySQL 5.x and the
incompatibility with the 4.x version of php I must run, I cannot
mysql_connect() -- I need to have the MySQL password altered by:

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

My question is, is there some way I can perform this MySQL command,
remotely, via say php, given how stuck I am per the above! -Ike


Jan 20 '06 #1
2 1072
Ike, I'm not sure if this helps but you can use mysqladmin to reset
your root password (or someone elses password, for that matter).

More info here (search for mysqladmin on this page):
http://dev.mysql.com/doc/refman/5.0/...rivileges.html

Jan 20 '06 #2
Adam Plocher wrote:
Ike, I'm not sure if this helps but you can use mysqladmin to reset
your root password (or someone elses password, for that matter).

More info here (search for mysqladmin on this page):
http://dev.mysql.com/doc/refman/5.0/...rivileges.html


.....or you can use the mysql client (where you type SQL DDL/DML comamnds at
a command prompt.

Both of these require shell access to a machine with the programs available
and which in turn has access to the mysql port on the DBMS so you might...

some_user@home:~ $ ssh we****@phpbox.mydomain.com
Password:
Last login: Fri Jan 20 20:58:42 2006 from console
webdev@phpbox:~ $ mysql db*****@mysqlbox.mydomain.com
Password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: x.y.z

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET PASSWORD FOR 'webdev'@'phpbox'
-> = OLD_PASSWORD('newpwd');

(if your starting from a MS Windows box get a copy of PuTTy)

HTH

C.
Jan 20 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: filesiteguy | last post by:
Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating. Unfortunately, this...
3
by: JStrummer | last post by:
I have a mySQL database located on a remote host's server. I would like to schedule a task on my local Windows computer to retrieve a backup/dump of this remote database. I have contacted my...
4
by: Ian Davies | last post by:
Hello all The following code allows me to connect to a local MySQL database on my pc from a VB6 project. **************************************************************************** ** Dim...
7
by: Ike | last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on 111.111.111.111 allowing all incoming and outgoing ports. I have a username and password setup, which CAN connect to this database,...
4
by: courtney.machi | last post by:
Hello, I am trying to connect to a remote mysql server through php. Here's the code: mysql_connect("my.hostname.edu", "username", "password") or die (mysql_error());...
2
by: Martin | last post by:
Hi all. I have a fully functional page hosted on my PC that uses PHP and connects to MySQL on my PC to generate it's code. I now have some web hosting available which includes both PHP and...
2
by: dronkanoki | last post by:
I am attempting to set up myODBC 3.51 on Win XP Pro to a remote MySQL Linux server. I get the following error: Access denied for user: 'username@ipaddress.serviceprovider.net' (Using password:...
4
by: Jerim | last post by:
I have a script on one server, trying to access the MySQL database on another server. The server with the script is on an outside network, hosted with another company. The MySQL server is here in...
1
by: jmohan | last post by:
Dear Sir/Madam, I develop a website in asp.net with c#. And also, I develop a toolbar in the toolbar studio separately. Aim of the Website: Enabling the visitors to become a member of our...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.