# /etc/init.d/mysql stopStopping MySQL database server: mysqld.
# mysqld_safe --skip-grant-tables &[1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started
# mysql -u rootWelcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit# /etc/init.d/mysql stopStopping MySQL database server: mysqld STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[6186]: ended [1]+ Done mysqld_safe --skip-grant-tables
# /etc/init.d/mysql start
# mysql -u root -p
1 | ctrl slot=3 modify dwc=enable forced |
proxy=http://someproxyserver:port/ # Shouldn't need to be quoted, remember the trailing slash proxy_username=myname # The username you authenticate to your proxy with, if applicable proxy_password=mypass # The password you provide to your proxy, if applicable
In /etc/wgetrc :
http_proxy=http://myname:mypass@someproxyserver:port/ # All in one string this time no_proxy=localhost,127.0.0.0/8,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16 # Hosts to exclude from proxying
If you are using an https proxy:
https_proxy=https://myname:mypass@someproxyserver:port/Quoting is not needed (or helpful) in any of these, but if you have special characters in passwords (especially : or @) and are having problems you probably need to escape them with backslashes.
“curl is a command line tool for transferring data with URL syntax, supporting DICT, FILE, FTP, FTPS, Gopher, HTTP, HTTPS, IMAP, IMAPS, LDAP, LDAPS, POP3, POP3S, RTMP, RTSP, SCP, SFTP, SMTP, SMTPS, Telnet and TFTP. curl supports SSL certificates, HTTP POST, HTTP PUT, FTP uploading, HTTP form based upload, proxies, cookies, user+password authentication (Basic, Digest, NTLM, Negotiate, kerberos...), file transfer resume, proxy tunneling and a busload of other useful tricks.”So after downloading the curl version for Windows, I opened a command prompt and browsed to the folder where I extracted the zip file.
| cd /tmp |
| wget |
| sh ./ls-mvkw-bootstrap_1.2-7_arm.xsh |
| mv /etc/init.d/optware /etc/init.d/rc.optware |
| ipkg update |
root accounts:
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
Write the UPDATE and
FLUSH statements each on
a single line. The UPDATE
statement resets the password for all
root accounts, and the
FLUSH statement tells the
server to reload the grant tables into memory so that it
notices the password change.
C:\mysql-init.txt.
--init-file option
(notice that the backslash in the option value is
doubled):
C:\> C:\mysql\bin\mysqld-nt --init-file=C:\\mysql-init.txt
If you installed MySQL to a location other than
C:\mysql, adjust the command
accordingly.
--init-file option at
startup, changing each root account
password.
--console option to the
command if you want server output to appear in the
console window rather than in a log file.
--defaults-file option:
C:\>The appropriate"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe"--defaults-file="C:\\Program Files\\MySQL\\MySQL Server 5.0\\my.ini"--init-file=C:\\mysql-init.txt
--defaults-file setting
can be found using the Services Manager: From the
menu, select
, then
, then
. Find the MySQL
service in the list, right-click it, and choose the
Properties option. The Path
to executable field contains the
--defaults-file setting.
C:\mysql-init.txt.
root using the new password. Stop the
MySQL server, then restart it in normal mode again. If you
run the server as a service, start it from the Windows
Services window. If you start the server manually, use
whatever command you normally use.
root accounts. The
instructions assume that you will start the server so that
it runs using the Unix login account that you normally use
for running the server. For example, if you run the server
using the mysql login account, you should
log in as mysql before using the
instructions. Alternatively, you can log in as
root, but in this case you
must start mysqld
with the --user=mysql option.
If you start the server as root without
using --user=mysql, the
server may create root-owned files in the
data directory, such as log files, and these may cause
permission-related problems for future server startups. If
that happens, you will need to either change the ownership
of the files to mysql or remove them.
mysql).
.pid file that contains
the server's process ID. The exact location and name of
this file depend on your distribution, host name, and
configuration. Common locations are
/var/lib/mysql/,
/var/run/mysqld/, and
/usr/local/mysql/data/. Generally,
the file name has an extension of
.pid and begins with either
mysqld or your system's host name.
kill (not kill -9)
to the mysqld process, using the path
name of the .pid file in the
following command:
shell> kill `cat /mysql-data-directory/host_name.pid`
Use backticks (not forward quotation marks) with the
cat command. These cause the output
of cat to be substituted into the
kill command.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
Write the UPDATE and
FLUSH statements each on
a single line. The UPDATE
statement resets the password for all
root accounts, and the
FLUSH statement tells the
server to reload the grant tables into memory so that it
notices the password change.
/home/me/mysql-init. The file
contains the password, so it should not be saved where
it can be read by other users. If you are not logged in
as mysql (the user the server runs
as), make sure that the file has permissions that permit
mysql to read it.
--init-file option:
shell> mysqld_safe --init-file=/home/me/mysql-init &
The server executes the contents of the file named by
the --init-file option at
startup, changing each root account
password.
/home/me/mysql-init.
root using the new password. Stop the
server and restart it normally.
[ NOTE ]: You might need to run it as a Unix System superuser (root) - depending on how the system is configured, and what permissions your Unix account is granted) |
ps -ef | grep mysql - checks if mysql/mysqld is one of the running processes. pkill mysqld - kills the daemon, if it is running. |
mysqld_safe --skip-grant-tables & |
mysql -u root mysql
|
UPDATE user SET password=PASSWORD("ualue=42") WHERE user="root"; FLUSH PRIVILEGES; |
/etc/rc.d/rc.mysql start |
/etc/init.d/mysql start |
/etc/rc.5/mysql start |
mysql -u root -p mysql |
Choose Language & HELP :-)) entry.Windows entry.Fix Boot of Windows entry.A great article for running both PHH4 and PHP5 at the same time. :)
"
Whilst the majority of web applications are hosted on Linux, most developers use Windows. Installing Apache, PHP, and MySQL on your Windows PC is recommended and has become much easier. However, few developers can test their pages in PHP 4 and PHP 5 on the same machine at the same time - but it is possible…
Environment overviewThis article will not describe every step in detail, but it should give you enough information to create your own multi-PHP web development environment:
Note that the latest versions of PHP 5 run very slowly if you use the CGI binary. Defining it as a module solves this issue.
The freeware/open source software you’ll need is:
Both Apache and MySQL provide Windows installers, so just run them. All going well, you should then be able to navigate to http://localhost/ in your browser.
Extract PHP 4 to C:\php\php4 and PHP 5 to C:\php\php5. Follow the instructions for configuring your php.ini file, but ignore the Apache setup details for now - we’ll cover that below. One setting that may catch you out is extension_dir - for PHP 5 use:extension_dir = "C:\php\php5\ext"
and for PHP 4 use:extension_dir = "C:\php\php4\extensions\"
You can now uncomment any extensions you wish to use, e.g. extension=php_mysql.dll in PHP 5’s php.ini.
Now all the files are in place, we’ll define the local domains test and test4. This is done by editing the hosts file, located in %WINDOWS%/system32/drivers/etc. Add the following lines:127.0.0.1 test
127.0.0.1 test4
You can update your system using the command ‘nbtstat -R’, but you’ll need a reboot soon so don’t worry about it!
Now go to the Control Panel, open System, click the Advanced tab, and click Environment Variables. In the System variables section, click “Path” in the list followed by Edit. Add “;C:\php\php4;C:\php\php5″ to the end of the Variable value line.
Now reboot to make sure the settings are applied.
Configuring ApacheThe Apache configuration file is normally located at %PROGRAMS%\Apache Group\Apache2\conf\httpd.conf You’ll need to locate and edit the following settings.
Set the server to listen on port 80 (the default) and port 81:Listen 80
Listen 81
Ensure your root folder is set correctly (note the forward slash):DocumentRoot "C:/WebPages"
Add php files to the directory index, e.g.DirectoryIndex index.html index.php
Just before the Virtual Hosts section, define PHP 5 as a SAPI module:# PHP5 module
LoadModule php5_module “c:/php/php5/php5apache2.dll”
AddType application/x-httpd-php .php
PHPIniDir “C:/php/php5″
NameVirtualHost *:80
NameVirtualHost *:81
# localhost:80 - PHP5
<VirtualHost *:80>
DocumentRoot C:/WebPages
</VirtualHost>
# localhost:81 - PHP4
<VirtualHost *:81>
DocumentRoot C:/WebPages
ScriptAlias /php/ “c:/php/php4/”
Action application/x-httpd-php4 “/php/php.exe”
AddHandler application/x-httpd-php4 .php
</VirtualHost>
# test:80 - PHP5
<VirtualHost *:80>
ServerName test
DocumentRoot C:/WebPages
</VirtualHost>
# test:81 - PHP4
<VirtualHost *:81>
ServerName test
DocumentRoot C:/WebPages
ScriptAlias /php/ “c:/php/php4/”
Action application/x-httpd-php4 “/php/php.exe”
AddHandler application/x-httpd-php4 .php
</VirtualHost>
# test4:80 - PHP4
<VirtualHost *:80>
ServerName test4
DocumentRoot C:/WebPages
ScriptAlias /php/ “c:/php/php4/”
Action application/x-httpd-php4 “/php/php.exe”
AddHandler application/x-httpd-php4 .php
</VirtualHost>
# test4:81 - PHP4
<VirtualHost *:81>
ServerName test4
DocumentRoot C:/WebPages
ScriptAlias /php/ “c:/php/php4/”
Action application/x-httpd-php4 “/php/php.exe”
AddHandler application/x-httpd-php4 .php
</VirtualHost>
Create a new file phpinfo.php in C:\WebPages\. Edit the file and add the line:<?php phpinfo(); ?>
Save it, then visit the following addresses in your browser:
Obviously, you can now define further virtual domains - perhaps one for every website you create. "