Mysql How to set password for root user

-
/opt/mysql/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/mysql/bin/mysqladmin -u root -h unknown password 'new-password'

Commenti

Posta un commento

Post popolari in questo blog

Joomla: how to connect to an EXTERNAL DB

-
Installing and Configuring Install the plugin called externaldb , then make sure you enable it! In Plugin Manager, configure your external database details for the database(s) you need.  DSN: Your name for the database to be used later on Hostname: Host where the MySQL server is Port Number: Defaults to 3306, but can change if needed Username / Password : Authentication details for the database Database Name: Name of the MySQL database to use Implementing The following code is a solution to using external databases. There is no way of using this without modifying some code. That out of the way, here's how to use it in that code. You can use Jumi module to insert PHP code in your article in joomla page. ExternalDB simply creates a new jDatabase object with your given connection details - nothing clever but simple to maintain connection details. Here's a sample of code from one of our components... // Create new ExternalDB instance, using the details tha...
Read more »

Solaris 10: How to restart network service without reboot

-
Adding or editing the IP address on a Solaris 10 server is different from the previous versions of the OS (Solaris 9, Solaris 8 etc). In the previous versions of the Solaris Operating System, you need to edit the /etc/hosts file and add/edit the entry for the IP address and the hostname. Example: 192.168.1.1 myhost However, in Solaris 10, you should edit the /etc/hosts file (a symlink to /etc/inet/hosts file) and the /etc/inet/ipnodes file and add an entry for IP address and hostname. Once done, restart the Network service using # svcadm restart network/physical or reboot the server for the changes to take effect. Although, the /etc/inet/ipnodes files is primarily for IPv6 only, without adding an entry to the file, the IP address (IPv4) doesn’t become active. This seems to be a known problem but the good news is this is now fixed in the Solaris 10 U4 (08/07 build). Also, ensure that the /etc/netmasks file with the network ID and the netmask.
Read more »