To execute queries on the MySQL database, you must access the command line MySQL client.
Step-by-step guide
STEP 1: Log in to your VoipNow server as root via SSH using your favorite console (e.g. Putty).
STEP 2: Execute the following command.
The output will provide a single line like the one below.
STEP 3: Run the next command.
mysql -u<DB_USER> -p<DB_PASSWD> voipnow
Note that you may equally run this command:
mysql -u`cat /etc/voipnow/.sqldb| awk -F':' '{print $2}'` -p`cat /etc/voipnow/.sqldb| awk -F':' '{print $3}'` -h `cat /etc/voipnow/sqldbase.conf | grep DB_MASTER | awk -F':' '{print $2}'` voipnow
STEP 4: Use the values obtained for the <DB_USER> and <DB_PASSWD> parameters.
STEP 5: Now you will be connected to your MySQL server and you will be able to run queries in the database.
Related articles
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 4.0 International.