MYSQL Archives - Page 2 of 2

MYSQL

Reset MYSQL root password – Linux

Reset MYSQL root password – Linux Log on to your Linux machine as the root user. The steps involved in resetting the MySQL root password are to stop the MySQL server, restart it without the permissions active so you can log into MySQL as root without a password, set a new password, and then restart […]

MYSQL, SQL

SQL Where values are not in another table

SQL Where values are not in another table [sql] select TCode from Tracking where not exists (select * from Task where Task.TCode = Tracking.TCode ) [/sql]

MYSQL

Select next available ID

Select next available ID ## Select the next available UID ## Do not delete users from unixuid and unix gid as there id’s may get re-used ######################################## [sql] SELECT min( r1.uid ) +1 AS next_available_uid FROM unixuid AS r1 LEFT OUTER JOIN unixuid AS r2 ON r2.uid = r1.uid +1 WHERE r1.uid >200 AND r2.uid […]

MYSQL

MYSQL – Replication

MYSQL – Replication Login to your mysql server: mysql -uBla -p Some useful commands SHOW SLAVE STATUS; SHOW MASTER STATUS; SHOW PROCESSLIST ; SHOW SLAVE HOSTS;

MYSQL

Reset MYSQL root password – Linux

SQL Where values are not in another table

Select next available ID

MYSQL – Replication

Recent Posts

Company Information

Our Services

Expertise

Main Headquarter

Other Offices