self.database1 = QtSql.QSqlDatabase().addDatabase('QMYSQL')
self.database1.setHostName('localhost')
self.database1.setDatabaseName('database')
self.database1.setUserName('root')
self.database1.setPassword('')
if self.database1.open():
    print('Successful')
else:
    print(self.database1.lastError().text())

username = self.userName1.text()
password = self.passwordSlot.text()
query = QtSql.QSqlQuery(self.database1)
credentials = query.prepare("SELECT * FROM credentials WHERE username = ? and password = ?")
if credentials:
    query.addBindValue(username)
    query.addBindValue(password)
    query.exec_()
    self.database1.close()
    print('Successfully logged in')
else:
    print('Falied')